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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.