Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join 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.

Reply
jmdh
Advocate IV
Advocate IV

Bug in a Query referring (indirectly) to an other Query

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.

4 REPLIES 4
wynhopkins
Most Valuable Professional
Most Valuable Professional

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?

MVP | Author of Power BI for the Excel Analyst | Speaker | Power BI & Excel Developer & Instructor | YouTube- 5 million views | Fan of Power Query & XLOOKUP | Purpose: Making life easier for people through applying and sharing knowledge.
v-ljerr-msft
Microsoft Employee
Microsoft Employee

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? Smiley Happy

 

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. Smiley Happy

 

Regards

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.