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!
It worked!!! thank you