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: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

tylerabbott

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

Submitted by Advocate I 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:
34 Comments (34 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
Tuesday
I have this error on a few large reports also.
This widget could not be displayed.
Idea Statuses