P1 Premium Capacity Metrices refresh failed

[itsranga]

Im using Premium Capacity Metrices dashboard its refresh failed, i know this is automatically created dashboard so we cant edit the dataset but im getting error when i try to refresh

Data source error: Expression.Error: The column 'Column1' of the table wasn't found.. Column1. . The exception was raised by the IDbCommand interface. Table: RefreshWaitTimes.
Cluster URI: WABI-WEST-US-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 37e4277e-94ed-4455-9d31-939b3a7d04f0
Request ID: 5263be7a-180b-ecd5-523e-338885a36655
Time: 2025-01-17 11:06:06Z

the Error is column1 is missing but we can't edit the dataset , how to solve this issue 
note:  i can't able to download this file but i have admin access

[itsranga · Accepted solution]

the Premium Capacity Utilization and Metrics app has been deprecated as of October 1, 2023

Install and use the Microsoft Fabric Capacity Metrics app for monitoring Power BI Premium capacities

Installation Install the Microsoft Fabric capacity metrics app - Microsoft Fabric | Microsoft Learn

[v-csrikanth]

Hi @itsranga 

I wanted to check if you had a chance to try the above suggested approaches.
Please let us know if you need any further assistance.

Looking forward to your update!

If the above information helps you, please give us a Kudos and marked the reply as a solution.

Thanks,
Cheri Srikanth

[Poojara_D12]

Hi @itsranga 

To fix the Premium Capacity Metrics App refresh error:

1. Update the App: Ensure you’re using the latest version of the app.
2. Reinstall the App: Delete and reinstall it from the Power BI App Marketplace.
3. Check Admin Settings: Verify telemetry and metrics collection in the Power BI Admin Portal under Capacity Settings.
4. Check for Outages: Visit Power BI Support for any ongoing issues.
5. Contact Microsoft Support: If the issue persists, share the error details (Activity ID, Request ID, etc.) with Microsoft Support for resolution.

Since you can’t edit the dataset, the issue is likely on Microsoft’s side.

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS 

[rohit1991]

The error occurs because Column1 is missing or renamed in the data source, causing the refresh to fail. Since the Premium Capacity Metrics dashboard dataset cannot be edited:

1. Reinstall the App: Delete and reinstall the "Premium Capacity Metrics" app from Power BI Apps to refresh with the latest schema.
2. Check Source Schema: Verify if Column1 exists or has changed in the underlying API or data source.
3. Custom Monitoring: Use the Power BI REST API to create a custom capacity monitoring report if needed.
4. Contact Support: Provide the Activity ID, Request ID, and Cluster URI to Microsoft Support for further assistance.

If urgent, use Microsoft's Capacity Metrics Report Template for monitoring.

• Premium Capacity Metrics App Documentation: Manage and monitor Power BI Premium capacities
• Power BI REST API Documentation: Power BI REST API Premium Capacities

[ibarrau]

Hi. The premium capacity metrics has been deprecated. If you want to measure your dedicated capacity now you should use the Fabric Capacity Metrics App.

More info: https://learn.microsoft.com/en-us/fabric/enterprise/metrics-app

I Hope that helps,