Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
initsoftware
Regular Visitor

Reports API returns 401 (unauthorized)

We are using the API through JavaScript and accessing "https://api.powerbi.com/v1.0/myorg/reports" which returns a 401 (Unauthorized).

 

However for example using "https://api.powerbi.com/v1.0/myorg/groups" works and returns the groups of the powerbi user so our implementation should be correct. The app has all required permissions set in azure portal including "Read and Write all Reports". 

 

Any idea what could be the issue here?

3 REPLIES 3
Eric_Zhang
Microsoft Employee
Microsoft Employee


@initsoftware wrote:

We are using the API through JavaScript and accessing "https://api.powerbi.com/v1.0/myorg/reports" which returns a 401 (Unauthorized).

 

However for example using "https://api.powerbi.com/v1.0/myorg/groups" works and returns the groups of the powerbi user so our implementation should be correct. The app has all required permissions set in azure portal including "Read and Write all Reports". 

 

Any idea what could be the issue here?


@initsoftware

Could you register a new APP following this tutorial App registration and permissions and retry? I'm not reproducing your issue when having the app registered as the link.

Hi @Eric_Zhang,

 

looks like it is working now although I haven't changed anything in my implementation. Did anything change on your end? Now reports and dashboards sucesfully return values.

 

What would be the be the best way to access the data behind a tile from a dashboard? I am able to get the metadata through myorg/dashboards/dashboardID/tiles/tileID but what I'm really looking for is the data underneath.

 

Thanks for your help and hopefully you can point me in the right direction.

For any interested, I found my answer here: https://community.powerbi.com/t5/Service/How-to-identify-which-data-set-is-used-by-a-report-and-how-...

 

Unfortunatly it also seems that the API can only access datasets which have been created with the API (see here https://community.powerbi.com/t5/Developer/Power-BI-REST-API-Table-and-Row-query-return-with-404-err...).

 

This seems like a huge oversight and we will probably look for some other solution for our case. 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors