cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

4 REPLIES 4
Highlighted
Community Support
Community Support

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

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Resolver I
Resolver I

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

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

Highlighted
Community Support
Community Support

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

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.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

Highlighted
Resolver I
Resolver I

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

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!

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors