Forum Discussion
Query references other queries or steps, so it may not directly access a data source
This is related to privacy settings. For lots of details see here:
https://blog.crossjoin.co.uk/tag/formula-firewall/
If there are no privacy concerns with the particular data you're working with then the easiest solution is to ignore privacy levels entirely. This can be found under the options and settings as described here:
https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels
I THINK I GOT IT...
I was struggling with the same thing and I saw some other post from Matt mentioning something about problems when merging tables with different sources... Is like power bi questioning if you really have access to both, so it needs to make sure of that so the query works...
So, I merged a query of a table called area with a query of a table called quotation. I merged both queries in the quotation query.
What I did to fix the problem was, i copied the reference from the advance mode in the area and pasted inside the source code of the quotation.
Copied this:
and pasted here:
it works like a charm!
Thank you very much for sharing!! I got this same strange error and adding the reference from advance editor to both queries resolved it.
Syndicate_Admin
It fixed my problem, thanks a lot !Hi,
I am also facing the same issue. I am merging 2 queries and sometimes get the above error during refresh. Can you elaborate what step you added?
Thank you
Just delete all the connection that created by power bi automatically. Keep only connections created by you an drefresh. It will work
To be more elaborate these are the 2 queries which I am merging
Which step should I add in which query? As in the SS you have provided I can't see the merge step.
because PowerBI firewall doesn't let you combine two queries, you need to also include the code for creating the MasterBranch table inside this query.
Once that's done, you should be able to join them. Currently firewall will be blocking this query, as it's merging two sources
Thanks for your quick response. The problem is fixed now. I used a different approach.
The 2 tables had a relationship between them with 2 columns. So I was merging the 2 tables. Now instead I created a custom col by concatenating the 2 cols in both the tables. And created a relationship between the 2 tables using this new col. This approach solved this error as well as refresh from service showing incorrect values issue.
Thank you for sharing! This worked for me too.
It worked!!! thank you
