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-menakakota]

Hi @Asma-k  ,

Thanks for reaching out to the Microsoft fabric community forum. 

I would also take a moment to thank  @jennratten , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
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. 

Best Regards, 
Menaka.
Community Support Team  

[v-menakakota]

Hi  @Asma-k ,
Thanks for reaching out to the Microsoft fabric community forum. 

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 the response has addressed your query, please accept it as a solution so that other community members can find it easily. 

Best Regards, 
Menaka.
Community Support Team  

[v-menakakota]

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 the response has addressed your query, please accept it as a solution so that other community members can find it easily. 

 
Thank you. 

[jennratten · Accepted solution]

Hello @Asma-k - I recommend you check out the free FAUM solution - it does this all for you, provides clear instructions to get up and running quickly and includes great reports.

https://github.com/microsoft/fabric-toolbox/tree/main/monitoring/fabric-unified-admin-monitoring 

Here is a brief video with an overview.

https://youtu.be/G_-N2VMO8C0?si=lXqyaSc9NyHSHuYy