Forum Discussion

PowerBIFin's avatar
PowerBIFin
Advocate I
5 years ago

Power Query Editor Preview: No Data loaded in All Existing Tables (? in every single table)

I have an existing Power BI Reports with data tables from various data sources (SQL Servers, excel files). This report is working fine, can refresh the data successfully from the Power BI Web Service...
Need Help
debraa's avatar
debraa
Regular Visitor
4 years ago

Hi,

 

I have the same issue. My published reports continue to refresh but the desktop version wont load any data in Query editor. Even if I make changes in Advanced Editor and try to apply the changes, the load continues indefinitely. Even from local excel files.

 

I have tried downloading latest versions, clearing caches, restarting PC.

 

I had this a few months ago and it partially resolved itself. Sometimes its when I work from home that it suddenly works. However, the last time I had a colleague open the file and then try to edit (even though he didn't have access to the sources). He then saved it and when I re-opened it, I was able to edit the query once before it happened again.

 

UPDATE EDIT: this time updating to the new version seemed to work. Still had to wait 25 minutes though