Forum Discussion
Query references other queries or steps, so it may not directly access a data source
Hi Everyone, I am facing the the following issue and hoping someone can point me in the right direction. I get the following error message each time when initially hitting refresh in a couple report...
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
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.
I only had about 7 steps, so I just manually rebuilt the second query. I am sure there is probably a better way.