Query Editor stuck refreshing forever

[JohnCavil]

Hey guys,

I am having a problem in my project with the query editor not being able to refresh or handle new queries.

Basically if i try to refresh the data or i add a new step, such as just duplicating a column, it will be stuck trying to load/refresh forever. I've waited for up to an hour and nothing happens. This even happens if i delete all my data sources and try to pull in a small excel sheet. Just add source - excel and it's stuck doing nothing.

I've tried updating powerbi, testing it on another computer and so on. I've also tried to make sure the privacy settings and such are ok.

Refresh works from the powerBI page, just not the query editor. Any steps i try to add or any of my tables i try to refresh and it is just stuck.

Anyone had a similar problem?

[lbendlin · Accepted solution]

if you can get to the Options screen try clearing out the caches.

[lbendlin]

I've seen that after using excessive table merges. But you say this also occurs with fresh small queries? Even when your data source is a CSV file?

[JohnCavil]

Hey,

Yea, it does. I mean we do a huge append with our data, and we have a few tables with millions of rows (these we don't merge or append). But even if i delete all of our tables and just try to import an excel file it's stuck.

I can delete all tables in my entire project, and it still wont allow me to do anything in the query editor at all. The only thing i can do is duplicate a table. But i can't do anything on an table (add steps) or get new data in. The project worked just fine like a week ago, and wasn't even slow or anything.

I've let it sit now for 5 hours and nothing happens. So clearly there is some sort of error but all i get are those 3 little yellow dots in the top to indicate it's loading something.