Queries being blocked on refresh

[negbc]

Hi,

Can anyone help explain why a renaming column step will cause this error? Not sure how renaming a column would access a different data source?

[Kaviraj11]

Do you have this privacy selected?

[negbc]

Yes

[Kaviraj11]

I found this post. Hopefully, you can make sure you everything is selected as required.

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

[negbc]

Thanks, the solution presented in the link was just to ignore all privacy levels for the files though, which I don't want to do. 

[Kaviraj11]

Can you share the M Query from Advance Editor in Power Query?

[negbc]

see below. I already adjusted the privacy levels of both tables I joined to match.