Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

usage metrics report data from power BI API

  Hi, I am looking to retrieve usage metrics report data from the Power BI API and save it in Fabric Lakehouse to maintain historical records. Since the usage metrics report in Power BI Servi...
Need Help
Tips and Tricks
  • ibarrau's avatar
    ibarrau
    1 year ago

    Hi. The Power Bi Rest API request is under the "Admin" category. That means if you are authenticating with a Master user (user and password), then the user must be Fabric Administrator to use those requests. Otherwise you can use Service Principal for this approach. Once you register the app create a secret. Then that App can authenticate with client id and secret key. In order to get data from Admin category with service principal, you need additional configuration at the Tenant Settings admin portal. This two:

    Only then you will be able to get Activity Events from the tenant.

    I hope that helps,

     

     

ibarrau's avatar
ibarrau
Super User
1 year ago

Hi. The Power Bi Rest API request is under the "Admin" category. That means if you are authenticating with a Master user (user and password), then the user must be Fabric Administrator to use those requests. Otherwise you can use Service Principal for this approach. Once you register the app create a secret. Then that App can authenticate with client id and secret key. In order to get data from Admin category with service principal, you need additional configuration at the Tenant Settings admin portal. This two:

Only then you will be able to get Activity Events from the tenant.

I hope that helps,