Forum Discussion

itsranga's avatar
itsranga
Helper I
1 year ago
Solved

P1 Premium Capacity Metrices refresh failed

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

Need Help
Show and Tell

5 Replies

  • rohit1991's avatar
    rohit1991
    Super User
    1 year ago

    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.

     

     

  • Poojara_D12's avatar
    Poojara_D12
    Super User
    1 year ago

    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 

  • v-csrikanth's avatar
    v-csrikanth
    Community Support
    1 year ago

    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