"Working on it" Error Pop up, stays on forever

[Joorge_C]

Hey Guys,

so just spotted this today in 2 different machines in 2 different PBI Desktop Files.

After finishin Query changes and appying them, PBI loads new data and when it finishes, it just shows a "Working on it" message for indefinate time. I waited 1 hour and it was still there.

I have latest PBI version that came out. Looks to be some kind of glitch.

Anyone else seen this?

Thanks

[v-jayw-msft]

Hi @Joorge_C ,

Can you show more details?

What data source your are using? How many data do you have? Did this happend before?

Best Regards,

Jay

[Joorge_C]

Hello @v-jayw-msft ,

First time happening.

The PBI is a 35mb file that connects to about 6 very small sharepoint lists, 2 sql sources with about 3.5MM rows total and 3 other small excel files.

File has always worked without issues, and now after applying a few changes in some queries, the data refresh loads fine and quick, but when it finishes I have that "Working on it message".

I just left my machine overnight, with the message loading to see if it would do something, but no luck.

Thanks

[v-jayw-msft · Accepted solution]

Hi @Joorge_C ,

It's wierd.

Try roll back the query changes and see if this issue still exists. If not the problem might be on the query.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Joorge_C]

Hey Jay,

Thanks for your help.

I was able to find the problem. I looked deeper into one query and found some extra lines that did not need to be there. Funny thing is these didnt cause an error if I was to refresh or do any regular work. Only now that I had dome extra query and other changes on top of it, thats when it caused the error.

So I was able to simply and remove them and my PBI is now working fine.

Thanks a lot!