Forum Discussion

AnandGNR's avatar
AnandGNR
Helper I
1 year ago
Solved

Usage Metrics Report Takeover

Hi All, I recently took over ownership of a Usage Metrics report and its semantic model (Early July, 25) in Power BI Service, originally created by a former employee who left at the end of June, 25....
Need Help
  • AnandGNR's avatar
    AnandGNR
    1 year ago

    HI v-menakakota : This model does not have a manually configurable refresh option. I did it using APIs.

     

    Thanks,

    Anand

AnandGNR's avatar
AnandGNR
Helper I
1 year ago

Hi All, 

Thanks a lot for the comments! Really helpful. 

 

WishAskedSooner: It does appear to be a bug.I tested for a sample report  in a dev workspace and looked at the model configs and it refreshed for my creds with OAuth. So this issue seems to be related to the takeover process for existing reports as detailed by Deku / v-menakakota.

 

 v-menakakota : Is there a way to determine which reports were selected when the original metrics report was created when using multiple reports?

 

The way the documentation puts it, a particular report " Retail Analysis Sample" is selected to create the report.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics#create-and-view-a-new-usage-metrics-report

 

Snip below for my usecase:

 

1. How is the report created for multiple selections?

2. Is there a way to determine the selections in the existing model?

 

  • v-menakakota's avatar
    v-menakakota
    Community Support
    1 year ago

    Hi AnandGNR ,

    Thanks for the update,it does seem like the issue is specifically tied to the ownership change especially in cases where the usage metrics report was originally created using multiple report selections.

    From what I’ve seen, Power BI doesn’t actually keep a record of which reports were selected when the metrics model was first generated. That detail isn’t exposed in the UI or stored in a way we can easily retrieve later.

    At this point, the cleanest and most reliable approach would be to recreate the usage metrics report by reselecting the intended reports. This ensures the new report and dataset are fully connected to your credentials and avoids the OAuth issue going forward.

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.   

    Best Regards, 
    Community Support Team  

    • v-menakakota's avatar
      v-menakakota
      Community Support
      1 year ago

      Hi AnandGNR ,

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you

      Thank you,

      • AnandGNR's avatar
        AnandGNR
        Helper I
        1 year ago

        Hi v-menakakota : I have a few updates since.

        1. I was trying to detemine if I could figure out the multiple reports used on the current report by looking at the datamodel this while to proceed with a delete and rebuild report approach.

        2. But suddently as of now,  it allowed me to take over the data credentials from the previous user (as per the documentation) without triggering the OAuth2 error I initially faced (screenshot shared in my earlier post) for no apparent reason.(confirming bug behavior) 

         

        3. Since it now takes my credentials without error: how can I resume scheduled refresh:

        Per the MS doc section:https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-modern-usage-metrics#usage-metrics-report-semantic-model

         

        Thanks,

        Anand