Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Desktop Refresh Error: Query "references other queries or steps ... "

Submitted by Anonymous on ‎07-07-2022 06:41 AM

On nearly every report I have in Power BI Desktop, I refresh the data and get this error message on random tables/queries in my dataset. To 'fix' it, I have to open the Power Query Editor, refresh all previews in there, then close the editor and refresh the data in the report view again - and everything refreshes no problem. So, it's not actually an issue with my queries at all - it just seems to be a bug in PBI Desktop.

tylerabbott_0-1657201178877.png

 

Status: Needs Info
See more ideas labeled with:
36 Comments (36 New)
Comments
C4YNelis
Advocate III
Advocate III
‎11-05-2024 12:24 AM

I too still experience this error, although it feels I am getting this error less often than before. I never kept count though.

Grey80
Regular Visitor
‎11-10-2024 05:44 PM

I'm also getting this error on a daily basis. 

Feels insane that this bug was raised years ago and is still not resolved?

GaryKnott
Regular Visitor
‎11-11-2024 02:12 AM

I just resolved the issue in my file! One of my source files was an Excel file containing 4 tables and it was saved as XLSB. I opened and resaved this source file as XLSX and rebuilt the related queries in PBI, then the refresh errors disappeared!

charlesbahr
Regular Visitor
‎12-24-2024 04:04 AM
I have this error on a few large reports also.
Neil_Message
Frequent Visitor
‎01-14-2025 02:21 AM
I am also getting this error. On one query it is a simple append of the tables before it that I have cleaned.
James-PBI
Advocate I
Advocate I
‎02-20-2025 06:40 AM
Same issue here. Refreshing in PBI desktop gives the error. Open Power Query, refresh all, then close & load. Then try refreshing again and no error. Clearly a bug, since no code is being changed.
Idea Statuses