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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
khregs
Advocate II
Advocate II

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 from a visual to Excel. Clicking the ellipsis > Export data function on a visual displays the Export Data dialog box, but when the "Excel" option is chosen, the resulting file is not downloaded to the browser. Note the "CSV" option does work as expected.

 

F12 devtools indicate the service endpoint (https://wabi-canada-central-redirect.analysis.windows.net/export/xlsx) returns a 403 Forbidden error with response message "API is not accessible for application".

 

Can anyone on the forum advise what the issue is here?

 

Thanks,
Craig

 

 

6 REPLIES 6
maxtheman
Regular Visitor

 

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.

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. 

Hi @maxtheman 

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

Hi @khregs / @maxtheman  ,

 

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-...

 

Capture.JPG

 

 

You have to use Master account approach in this kind of situation.

 

 

Hi,

Thanks for the reply. I forgot about this one 🙂

First, the reports in question were not in My Workspace, but this is good advice for anyone else who stumbles across this thread. 

Second, the Excel export functionality has been working as expected with SP auth for a while now. I think the issue fixed iteself last May when SP auth went to GA status. Can't remember specifics now. 

Thanks again,

Craig

khregs
Advocate II
Advocate II

Note that exporting to Excel works perfectly well from the demo app shown here:

https://fleetdemoapp.azurewebsites.net/ 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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