Forum Discussion

Anonymous

Not applicable

7 years ago

PBI Embedded App Owns Data - Export Data from visual to Excel fails with 403 Forbidden error

Hi, My team is building a web app with embedded Power BI reports using the app-owns-data method with service principal authentication. One key feature for our users is the ability export data...

Anonymous

Not applicable

7 years ago

I have same issue. If I authenticate as a user I can do both. As a service principal, only csv works. The difference in the way how it does it:

https://wabi-canada-central-redirect.analysis.windows.net/export/xlsx
for excel and this one for csv
https://wabi-canada-central-redirect.analysis.windows.net/explore/querydata

I suspect that my service principal is missing some permissions but can't figure out which one.

Anonymous
Not applicable
7 years ago
In my case the issue was caused by using Service Principal account. According to the support, this option has been in preview and will be GA sometime in May.
- Anonymous
  Not applicable
  7 years ago
  Hi Anonymous
  Apologies for not replying back sooner...
  Yes! My team just got back to looking at this problem last week and we were able to make it work by removing the Service Principal authentication and using Master User method instead. Not ideal, but at least it works.
  Thanks for relaying the news that Service Principal will be GA later this month. Will keep my eyes open for the announcement.
  Cheers,
  Craig
  - Jayendran
    Solution Sage
    6 years ago
    Hi Anonymous / Anonymous ,
    
    This is because you are trying to call some Reports/Dashboards that are in My Workspace using the SPN autentication. Currently this is the known limiation for SPN
    
    https://docs.microsoft.com/en-us/power-bi/developer/embedded/embed-service-principal#considerations-and-limitations
    
    You have to use Master account approach in this kind of situation.