topic Re: usage metrics report data from power BI API. in Data Engineering

usage metrics report data from power BI API.

Anonymous — Tue, 20 May 2025 07:33:48 GMT

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:

How can i resolve authentication issue?
Is there any easier way to solve this?
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.

Re: usage metrics report data from power BI API.

jennratten — Mon, 19 May 2025 23:54:05 GMT

Hello @Anonymous - 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

Re: usage metrics report data from power BI API.

v-menakakota — Mon, 26 May 2025 06:56:04 GMT

Hi @Anonymous ,

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

Re: usage metrics report data from power BI API.

v-menakakota — Thu, 29 May 2025 07:06:43 GMT

Hi  @Anonymous ,
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

Re: usage metrics report data from power BI API.

v-menakakota — Mon, 02 Jun 2025 04:33:48 GMT

Hi  @Anonymous ,

Thank you.