Report on PBI Service using api.powerbi.com

[mike12345262262]

I need to create a PowerBI report that lets us know who is viewing which PBI reports, how many views to they get a day, which reports are not used etc.  I would like to use the PowerBI API as a datasource.  I found a good artilce about a month ago, but now I can not find.

If I browse to https://api.powerbi.com/v1.0/myorg/reports I get "Access to api.powerbi.com was denied".  If I use Web datasource in PBI and try to connect, I get "Access to the resource is forbiden".

I would like to see what data the API exposes and write a report, so we know which reports are being used (usage metrics) and which are not.

Any help appreciated.

[v-jtian-msft · Accepted solution]

Hello,Gabry ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hi,@mike12345262262 .I am glad to help you.
1. Regarding the 403 error you encountered when accessing the web site. Usually this is due to unauthorized access, you need an access token.
I hope the following issue can help you
URL:
https://community.fabric.microsoft.com/t5/Developer/Error-403-Access-to-api-powerbi-com-was-denied/m...

2. About using Power BI API to get usage metric details

I hope the following issue will help you, here are some suggestions on how to use the API to get usage metric details.
You need to ensure that the amount can get the relevant access rights, otherwise you may be mentioned HTTP ERROR 403.

URL:
Solved: Re: How to fetch usage metric details through Powe... - Microsoft Fabric Community
Solved: How to get Power Bi report usage metrices and perf... - Microsoft Fabric Community
Solved: Monitoring usage for shared reports via Public Web... - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Gabry]

Hello,

Are you aware of the automatically generated report on the service when you click on the semantic model?