Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
weadick
New Member

Capacity Metrics Analysis - There was an error when processing the data in the database

We loaded the Capacity Metrics Analysis report on the new version of P1.

The report/dashboard was working fine for a few months but now I get the message

"There was an error when processing the data in the dataset"

and 

Couldn't load the data for this visual

Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details
 
This is on the report tool provided by Microsoft so it is not something new or customized.
It works for some of our team but not myself. It is a management tool so we have not rolled it out to 1200 users it is only to the team responsible for the P1 which is about a dozen.
They added me to the board and also made me an admin so it does not look to be authentication issue and it was working at one time. No I do not know what changed when it stopped working, not away of any changes and it works for other users just not me.
 
thoughts?
thanks in advance for your time.
1 ACCEPTED SOLUTION
weadick
New Member

found the cause of the issue.

It is a legacy message. We have 5x P1's and by default the Capacity Name = Empty > which generates the error message.

If I select "my" P1 the error message still shows as I move through my pages but the data seems to be okay.

If I click on the "X" the message goes away and the data does not change. 
I assume it is just a legacy message stuck as there likely is no refresh on the messaging area when the view is updated.
I assume it is just a ghost message and it will be fixed in a future release. There may be the option to set one of the spaces as "default" but we do not want the 5 owners poking around eachother's P1s so "it is what it is".

thanks for the help
Chris

 

View solution in original post

1 REPLY 1
weadick
New Member

found the cause of the issue.

It is a legacy message. We have 5x P1's and by default the Capacity Name = Empty > which generates the error message.

If I select "my" P1 the error message still shows as I move through my pages but the data seems to be okay.

If I click on the "X" the message goes away and the data does not change. 
I assume it is just a legacy message stuck as there likely is no refresh on the messaging area when the view is updated.
I assume it is just a ghost message and it will be fixed in a future release. There may be the option to set one of the spaces as "default" but we do not want the 5 owners poking around eachother's P1s so "it is what it is".

thanks for the help
Chris

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.