Forum Discussion

Synik_PBI's avatar
Synik_PBI
Icon for Helper II rankHelper II
3 years ago
Solved

Usage Metrics - Not refreshing/unable to view in service

Greetings everyone!    I have a bit of an odd case and I hate to present it as such because I'm the middleman here between my company's PBI admins and any suggestions here, so I might not be able t...
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , Synik_PBI 

    Thanks for your quick response!

    Here is my understand for your question:
    (1)Here is two datasets in my system storage area of the workspace:

    This is related to the "New Usgae report on" is open or not .

     

    The "Usage Metrics Report" dataset is created when the "New Usages report on" is opening.

    The  "Report Usage Metrics Model" dataset is created when the "New Usages report on" is not opening .

    And for i recommend you to use the new metrics dataset .

    For more information, you can refer to :
    Announcing: Improved report usage metrics in modern workspaces | Microsoft Power BI Blog | Microsoft Power BI

     

    (2)When you first launch the usage metrics report, Power BI automatically creates a Usage Metrics Report dataset. The usage metrics report relies on that dataset. Power BI then refreshes this dataset daily. Although you can't change the refresh schedule, you can update the credentials that Power BI uses to refresh the usage metrics data.

    The Power BI backend will refresh data for you on a daily basis, and generally does not require you to configure it.

    And if you want to refresh the dataset , you can use the REST API to refresh it :
    Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

    And you can find the group id and dataset id in the url:

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

     

Synik_PBI's avatar
Synik_PBI
Icon for Helper II rankHelper II
3 years ago

v-yueyunzh-msft  Again thank you very much for walking me through this! 

I can confirm that I do see the dataset inside the Dataset settings area. I was able to take it over and make myself the owner. I'm still not seeing a way to refresh it though. Any ideas? From the link you gave - it appears there is no way to manually refresh it, so I will probably need to check back in 24hrs. 

EDIT: I also looked at your second screenshot and I do NOT see Usage Metrics in the system storage area of the workspace as it is listed in your screenshot. I do see one called "Report Usage Metrics Model," but the one inside the Dataset settings area is just called "Usage Metrics Report." 

 

EDIT2: Now the Usage Metrics Report has appeared in the workspace. I wonder why it wasn't there before...I hope by taking over the dataset this somehow prompted a refresh.

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi , Synik_PBI 

Thanks for your quick response!

Here is my understand for your question:
(1)Here is two datasets in my system storage area of the workspace:

This is related to the "New Usgae report on" is open or not .

 

The "Usage Metrics Report" dataset is created when the "New Usages report on" is opening.

The  "Report Usage Metrics Model" dataset is created when the "New Usages report on" is not opening .

And for i recommend you to use the new metrics dataset .

For more information, you can refer to :
Announcing: Improved report usage metrics in modern workspaces | Microsoft Power BI Blog | Microsoft Power BI

 

(2)When you first launch the usage metrics report, Power BI automatically creates a Usage Metrics Report dataset. The usage metrics report relies on that dataset. Power BI then refreshes this dataset daily. Although you can't change the refresh schedule, you can update the credentials that Power BI uses to refresh the usage metrics data.

The Power BI backend will refresh data for you on a daily basis, and generally does not require you to configure it.

And if you want to refresh the dataset , you can use the REST API to refresh it :
Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

And you can find the group id and dataset id in the url:

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

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

 

 

  • Synik_PBI's avatar
    Synik_PBI
    Icon for Helper II rankHelper II
    3 years ago

    Thank you v-yueyunzh-msft ! Hopefully last question. 

    I waited 24hrs with no luck on the refresh. I can try your API method to see if that works. This is the current error that is showing in the dataset settings: 

    Do you think the best way to resolve this might be an API refresh? I'm not sure if I can do that but I'll try....

    EDIT: Thanks so much for the multiple posts, v-yueyunzh-msft ! 
    Your API refresh link worked, I can confirm that the Usage Metrics is showing a refresh date of today. Woo!