cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NJ81858
Helper III
Helper III

Power Query Refresh

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:

PQ Error.PNG

 

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:

PQ Error code.PNG

 

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!

2 REPLIES 2
v-kkf-msft
Community Support
Community Support

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.

vkkfmsft_0-1663207496809.png

 

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors