Forum Discussion
Helper INew Usage Metrics report - no dataset
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!
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:
-
Open the workspace that contains the report for which you want to reset the Usage Metrics Report dataset.
-
In the black header bar at the top, select the Settings icon, then select Settings.
- Switch to the Datasets tab, and select the Usage Metrics Report dataset.
- Copy the workspace and dataset IDs from the URL displayed in the address bar of your browser.
-
In your browser, go to https://docs.microsoft.com/rest/api/power-bi/datasets/deletedatasetingroup, and select the Try It button.
- 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.
- 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 RegardsLucien
-
9 Replies
- v-luwang-msft
Community Support
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:
-
Open the workspace that contains the report for which you want to reset the Usage Metrics Report dataset.
-
In the black header bar at the top, select the Settings icon, then select Settings.
- Switch to the Datasets tab, and select the Usage Metrics Report dataset.
- Copy the workspace and dataset IDs from the URL displayed in the address bar of your browser.
-
In your browser, go to https://docs.microsoft.com/rest/api/power-bi/datasets/deletedatasetingroup, and select the Try It button.
- 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.
- 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 RegardsLucien
fr_jcAdvocate II
Lucien, thank you !! Nice and simple, it worked great..
-
- lbendlin
Super User
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.
