Error in query while refreshing the data in Power BI even when query is correct

[mukhan311]

Hi All,

I am getting an error in PowerBI when I try to refresh the report on certain steps in PowerQuery but when I open Powerquery and hit refresh the error dissapears and the query is working fine.

Attached is the error message for your reference.

These errors they disappear after opening power query and refreshing the file in the backend. 
Thank you.

Regards

[mukhan311]

Thank you, this helped me out a lot 

[Anonymous · Accepted solution]

Hi @mukhan311 

It may be affected by the privacy settings, you can set Ignore the Privacy Levels 'at Settings.

 And you can refer to the following link.

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

Chris Webb's BI Blog: formula firewall (crossjoin.co.uk)

Solved: Query references other queries or steps, so it may... - Microsoft Fabric Community

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.