Invoking Custom Function

[busybee]

I am having difficulty invoking custom function on my parameters. I have downloaded a Sample Financial Data.xlsx file. In my Practice.pbix file, I imported the financials sheet of the xlsx file. I wanted to create 2 dynamic parameters, Month1 Parameter and Month2 parameter. So I imported a second copy(financials Copy), created Query1 to get a distinct list of the Month Name column. Both the parameters use the query as source data. 

On my financials query, I have created 2 calculated columns, Month1 Sales and Month2 Sales that return the Sales for that month based on the 2 parameter values. On the same query, I have created a custom function SetMonthNames that utilize the 2 parameters created above. 

To get my final output dynamically, I have imported the financials worksheet again(financials Third). I created a Final Output table. It consists of Month1 Name and Month2 Name columns which dynamically import a distinct list of the Month Name column from the financials Third query. When I click on the Final Output query and Invoke Custom Function SetMonthNames Power BI gives the following error. Formula.Firewall:Query 'Final Output' references other queries or steps.


Any suggestions on how to solve this? 

Practice.pbix 

Financial Sample.xlsx 

[v-joesh-msft · Accepted solution]

Hi @busybee ,

You can try the following methods:

1. File -> Options -> Privacy -> Select “Ignore Privacy Levels”

2. Refer to the resources below:

Power Query Errors: Please Rebuild This Data Combination

Formula.Firewall Error in Power Query

Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.