Power Query Refresh

[NJ81858]

Hello,

So I have a pbix file that refreshes with new data each day, and when I click refresh in Power BI, there pops up this error:

I just don't understand what is causing this error, since nothng in the code for the query references another query or step. Here is what the steps are in advanced editor:

Another thing is that it doesn't always pop up and give an error, sometimes it runs smoothly refreshes free of errors and other times it gives me errors, so I would definitely appreciate some insight into how to alleviate all errors 100% of the time.

Unfortunately I can't share my pbix file, as there is sensitive data in there, so I apologize. Thank you in advance!

[v-kkf-msft]

Hi @NJ81858 ,

I see that you just referenced another query in the custom column, so please try disabling the privacy settings to see if that resolves the issue.

[NJ81858]

How would I go about pulling my data in and combining files without those transform files? I think that is what is giving me the errors, and I can't ignore privacy levels with the data that I have.