I can't refresh the user metrics report in Power BI service after consecutive errors

[emmabr]

The report in Power BI service stopped refreshing because the data source credentials needed updating. I have updated them but since then the report still has not updated/refreshed and becuase it's report created by Power BI itself and not published by me I can't see how to make it start refreshing again

Please help!

[v-menakakota]

Hi @emmabr ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-menakakota]

Hi @emmabr ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

The issue happens because even after updating the credentials, the built-in Usage Metrics dataset does not automatically reset.
Go to the workspace where the Usage Metrics report is located. Delete the broken Usage Metrics Model under Semantic Models. Open any report and click Usage Metrics  again Power BI will create a fresh dataset automatically.
Please try following these steps it may fix the issue.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[emmabr]

Hi, 

Thanks for this info

How would I delete it from the Semantic model as I can't see an option to delete?

[v-menakakota · Accepted solution]

Hi @emmabr ,

To delete the Usage Metrics dataset:

1. Go to the workspace where the report is.

2. Click on the Semantic models tab.

3. Find "Usage Metrics Model" (or a similar name).

4. Click the three dots next to it and choose Delete.

If you don’t see the delete option, double-check that you have at least Member or Admin access to the workspace ,viewers won’t see that option.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[Deku]

Have to use the APIs

https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/delete-dataset

[Deku]

You need to delete it and recreate it. Please see this guide

https://dadataguy.medium.com/a-step-by-step-guide-to-resetting-your-power-bi-usage-metrics-dataset-9...