Forum Discussion
Power BI Service refresh error when using custom M functions for REST API calls + on-prem gateway
Power Service and Power Query Team, please find a way so that REST API calls from various custom functions within local queries calling Table.AddColumn(a_table_as_prev_query, new_col_name, each cust...
Hi Element115 ,
You may consider to contact the support.
How to create a support ticket in Power BI - Microsoft Power BI Community
I will if all tests fail. atm though this page explained why the issue exists in the first place: https://learn.microsoft.com/en-us/power-query/dataprivacyfirewall
And thanks to other users saying that there can be no reference to external local queries from within the query where you call the REST API if you also combine data from other sources in that same query, I was able to get the Service to finally refresh without errors.
HOWEVER, that is not say that PQ could not be improved so that the naive user wouldn't have to resort to such ugly code gymnastics while at the same time still preserving data privacy.