Forum Discussion
Advocate IIFormula.Firewall: Query references other queries, so it may not directly access a data source.
Ken Puls blogged about this here
http://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
For people using multiple APIs and publishing to the Power BI Service in 2023, here is the solution that worked for me:
Power Query does not want you to reference another Query AND gather external data at the same time. So, if you need to use the result from one API to make more requests to another API you will have to do it all in the same Query.
Many suggest to just use the "always ignore privacy level settings" in the file settings, but it seems to me that it only works on your personal computer. When that same dashboard is published in the Power BI Service, that option will be ignored, and the dataset will not be able to refresh.
Here is the link from Power Query's documentation exlpaining how it works:
learn.microsoft.com/en-us/power-query/data-privacy-firewall#example-passing-data-from-one-data-source-to-another
Hope it helps 🙂
Any ideas on what to do if you need to use a function to iterate through paging?
Hello, from my experience, you can indeed use functions to make iterating requests (even in the power BI service). I would advise to avoid making your request functions too complicated though, like accessing multiple sources at the same time or passing data between queries.
That is the best I can say without knowing the details of what youre trying to do right now.
