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

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.