Status:
Needs Info
Desktop Refresh Error: Query "references other queries or steps ... "
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 al...
Yeah, it definitely makes sense that that would be a decent workaround. The only problem with that approach is that the Power BI service doesn't allow you to ignore privacy level checks, so if you add a data source with a different privacy level, once you publish it, it won't be able to refresh automatically and you won't know that until the refresh fails. Obviously, if you're careful, then that's a non-issue.
For what it's worth, I opened a ticket with Microsoft on this, so we'll see if we can get a real resolution.