New Usage metrics report won't refreshing or exporting to excel

[emmabr]

The last month I've been having an issue with the new user metrics reports not refreshing on some of the workspaces I am an admin for. I get the error messages that there are errors on the dataset and that the data source credentials need reconfiguring. I have reconfigured the data source and it is still not working.

I have also found that I can't pull the data into excel when the new usage metrics report toggle is on, which I thought I would do to see if that fixed my issue above. 

Any help would be really appreciated!

 

[Anonymous · Accepted solution]

Hi @emmabr ,

You can try to delete the existing Usage Metrics Report dataset . Then you can run View Usage Metrics again to generate a new dataset with its associated usage metrics reports.

For more details, please refer to:

Monitor usage metrics in workspaces (preview) - Power BI | Microsoft Docs

Besides, here are some similar threads that may helps you:

Solved: error when processing the data in the dataset. - Microsoft Power BI Community

Solved: There was an error when processing the data in the... - Microsoft Power BI Community

Regard to Analyze in Excel , you can see the link:

Create Excel workbooks with refreshable Power BI data - Power BI | Microsoft Learn

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[emmabr]

That button is already selected so I don't think that's the issue

[aj1973]

Hi @emmabr 

In power BI desktop check on this radio button