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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors