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?
Note that exporting to Excel works perfectly well from the demo app shown here: