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
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
Thanks, seems to have resolved the issue!
Hi AlexisOlson,
Like you mentioned here, I have ignored the privacy settings and tried to refresh. But when I do this, the columns in few tables changes its naming convention and also the data types. For Eg: If a table A has a column name Address and once I change the privacy settings to none and refresh, the column name changes to Addressname ...
I'm having the same issue. While I'm able to get beyond query refresh challenges after ignoring Privacy settings, columns were renamed when I made this settings change. Now, I'm trying to create a new Measure and can't use a column because it doesn't seem to think it exists. It is a column in a Table where another column was renamed by Power BI and now what I see in the Transformation Table does not match the Semantic Model Table. Thoughts?
Check your "Sample File" in the Transformation query and ensure it is looking at the file it should be.
