Forum Discussion
REST API doesn't return reports to new PowerBI users
Finally I have an explanation for this issue. Microsoft premium support confirmed it's expected behavior of the REST API:
REST API returns only directly shared reports with the current user and reports from installed PowerBI applications.
All the missing reports were from PowerBI applications that were not insatlled on the user account. PowerBI app installation is almost hidden feature, because all PowerBI clients from Microsoft install Power BI applications automatically when user opens a report. Unfortunately, there is no public API to install Power BI appliction. So this issue has no solution for third party apps. Workaround is only to navigate user to any Microsfot PowerBI client and install PowerBI applications by opening reports or instal them manually from marketplace.
Hi AmosHersch ,
thank you for your advice. It took me some time to find another tester who hasn't used PowerBI before. Unfortunately, calling refresh user permissions didn't help.
Here's what happened:
- User installed and launched our app on iPad.
- Successful MSAL authentication
- brokered authentication using MS Authenticator
- user confirmed consent for PowerBI as a first-time user
- Refresh user permissions - success
- Get PowerBI reports - success, but response contained 0 reports.
- Get PowerBI reports again after 5 minutes - success, but response still contained 0 reports.
- Refresh user permissions again - status 429 (just to check that previous call was really accepted by the server)
- Get PowerBI reports - success, but response still contained 0 reports.
- User installed and launched PowerBI iOS app on the same iPad.
- PowerBI app showed several PowerBI reports.
- Switched back to our app - get PowerBI reports - success, but response still contained 0 reports.
- Switched to PowerBI app and opened one of the reports
- Switched back to our app - get PowerBI reports - success, response contained 1 report (the one opened in PowerBI app)
This was exactly the behavior reported by the previous tester, before implementing user permission refresh.
By the way - is there a way how to "reset" user account to behave just like a first-time user? It's not possible for us to set-up temp accounts just for testing and I'm running out of a possible testers.
Best regards,
Petr Hoffman
Hi Petr,
This is the same exact issue I'm facing as well. Have you found any other way around ?
Regarding the "reset" user account, I used new workspace instead of creating the new user. Unless user explictly open the new workspace, API doesn't return the report associated with that workspace.
Regards,
Himal