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

[jmdh]

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.

[wynhopkins]

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?

[v-ljerr-msft]

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

[jmdh]

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.

[v-ljerr-msft]

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