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
For anyone that might still be listening in on this, or stumbles on it anew, it may not be the privacy setting.
I had the same issue a few weeks ago. Each time like the original poster, I accessed Power Query, did nothing, closed and applied, and it resolved itself.
Yesterday, I looked up this forum post, changed the privacy setting and it resolved the issue.
A bug got in my brain though, and reflecting on the error message, it just made no sense. Why not through a privacy error instead?
Taking this apart piece by piece, I discovered my using a separate query to retrieve only the latest report from a folder created the issue.
My original query gets all reports from a folder.
My second query gets only the latest report from that same folder.
When I created a second query, I copy/pasted the original query in there and modified the second query to only get the latest report from that folder. It worked and I thought nothing of it until this error began popping.
Today, rebuilding that "second" query from ground zero appears to have resolved the issue.
Again, oddly enough, "Ignoring" in the privacy setting also resolved the issue.
What exactly is going on here?
How did you rebuild that second query? I have the exact same query, getting the latest file from a folder. And I'm getting this annoying error.
Same. What do you mean "rebuilt"?
I only had about 7 steps, so I just manually rebuilt the second query. I am sure there is probably a better way.
Have you solve problem?
