Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have identified a Bug when Running a Query that calls a function that Accesses external data
I have a Pbix (Desktop) where I created functions that take their values in a table (Actions)
Actions is loaded from an Excel File with Get Data > Web
When I call one of these functions in a Query (also accessing an Excel file in the same area) , I have the error message:
Formula.Firewall: Query 'Test Query with Bug' (step 'Rename') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
If I go to File>Options>Privacy and click on "Ignore the Privacy Levels …" the message above disappears and everything work fine.
But when I publish to the Service (then edit my Data Source credentials etc.) and try a Refresh, I have funny errors, mainly :
Data source type: |
|
Processing error: | We cannot convert the value "[Function]" to type Function. |
Cluster URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
Activity ID: | 527bf804-a51c-4117-96b1-001d368fab6d |
Request ID: | 7fdf57cc-34fa-4b96-b32a-9900d76209b6 |
Time: | 2017-04-13 16:41:51Z |
After many tests to isolate the bug etc. I figured out that one way to bypass the problem is to create a table using Enter Data and paste there my Actions Table: then my functions, while still calling a Table, do not do it "externally"..
But this is a kludge.
This is a real issue since I cannot run my Pbix as in the Desktop and I am stuck after having worked quite a long time on this project.
I get the same issue, not using gateway but just refreshing from the online data sources.
I have a SQL string in one query that includes a reference to another query (a list of values to filter by), and can refresh on PBI desktop fine providing I set Ignore Privacy Settings to Always Ignore.
However, when trying to refresh on the Power BI Service it gives me the "Please Rebuild this data Combination" warning.
Any suggestions?
Hi @jmdh,
Based on my research, there is a gap in privacy functionality between desktop and service currently. Could you try enabling Fast Combine for your personal gateway, or configure the privacy level for your data source on Power BI Service if you're using the enterprise gateway to see if the refresh works?
Regards
Thank you.
I use the remove privacy option on the desktop andit does the trick, however,( i do not use any Gateway on teh Service) I could not find the similar option on the Service ie the ones you mention.
Hi @jmdh,
I use the remove privacy option on the desktop andit does the trick, however,( i do not use any Gateway on teh Service) I could not find the similar option on the Service ie the ones you mention.
So you may need to use the gateway to refresh your dataset on Power BI service in your scenario.
Regards
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
35 | |
22 | |
21 | |
14 | |
13 |
User | Count |
---|---|
26 | |
19 | |
18 | |
18 | |
16 |