usage metrics report data from power BI API

[Asma-k]

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 Service only shows data from the past 30 days, I want to store this information daily to analyze which reports are being used and which are not.

I have power bi pro license. I have registered an app in MS entra with the following API permissions:

• User.Read
• Dateset.Read.All
• Report.Read.All
• Tanent.Read.All
• Workspace.Read.All
• Workspace.ReadWrite.All
  

Despite having the necessary permissions, every authentication attempt results in an unauthorized access error, preventing me from retrieving the data from the API. I am unsure if I am using the correct API endpoints to access the usage metrics report. Following are my concerns:

1. How can i resolve authentication issue?
2. Is there any easier way to solve this?
3. Which API should I use to retrieve usage metrics report data accurately?

Note: I am just a tanent in MS entra, I do not have admin rights.

[v-priyankata]

Hi @Asma-k 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @Asma-k 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @Asma-k 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[ibarrau · Accepted solution]

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,