New Usage Metrics report - no dataset

[D_Lav]

Hi!

I am getting really weird response when i try to create new usage metrics report. 

First of all, My new report is not updated. Only shows data up to january 5

When i switch to classic i see everything, 

I read in an earlier post here that i should try to update credentials on the dataset. unfortunatly, my usage metrics dataset is not showing under settings-datasets,

I have tried to recreate usage metrics report several times and dataset is still not showing. 

Any help would be great!

[v-luwang-msft · Accepted solution]

Hi @D_Lav ,

Please first make sure the Usage Metrics setting in Tenant setting is enabled:

1.f you aren't the current dataset owner, you must take over ownership before you can update the data source credentials.

2.If you suspect data consistency or refresh issues, it might make sense to delete the existing Usage Metrics Report dataset. Then you can run View Usage Metrics again to generate a new dataset with its associated improved usage metrics reports. Please follow these steps to delete the dataset and then create a fresh data refresh report:

1. Open the workspace that contains the report for which you want to reset the Usage Metrics Report dataset.

2. In the black header bar at the top, select the Settings icon, then select Settings.

3. Switch to the Datasets tab, and select the Usage Metrics Report dataset.
4. Copy the workspace and dataset IDs from the URL displayed in the address bar of your browser.

5. In your browser, go to https://docs.microsoft.com/rest/api/power-bi/datasets/deletedatasetingroup, and select the Try It button.

6. Sign in to Power BI, paste the Workspace ID in the groupId text box and the dataset ID into the datasetId text box, and then select Run.
7. Under the Run button, verify that the service returns a Response Code of 200. That code indicates that the dataset and its associated usage metrics reports have been deleted successfully.

And I also tested it in my environment without the problem, you can also test it on your other dataset and see if the same problem occurs.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[fr_jc]

Lucien, thank you !!  Nice and simple, it worked great..

[D_Lav]

@lbendlin yes i agree and we have done that. Our superusers who also audit workspaces need this function. So i would really like to know if this is something that can be resolved. 

[lbendlin]

No, it cannot be resolved. Move on.

[D_Lav]

hard to tell over text if you mean to sound arrogant but not suitable answer from a super user in my opinion. If it cant be resolved i will take this forward to microsoft with a proper suportticket. 

[lbendlin]

I can only speak from my experience, and I am trying to save you from having to go through the same pain that we have been through with this topic. I gave you my recommendation, but ultimately it's your decision.

[D_Lav]

My question was not around how to build a report on usage data but why didnt usage metrics work (which is a microsoft feature). I appreicate your recommendation but i still found your reply arrogant and if you are a super user in this forum i would recommend to think about that text can come forward as arrogant even if thats not the case.  

i am going to create a support ticket for this and move on. 

[lbendlin]

Noted. I'll work on improving my phrasing.

here's another link you might find interesting: https://www.proserveit.com/blog/power-bi-usage-metrics-across-all-workspaces 

[lbendlin]

I would suggest you don't build any business critical processes around these reports. Instead, ask you O365 teant admin for the Power BI usage audit logs.