topic Re: Power BI REST API ExportTo not working on deployed web app in Developer

Power BI REST API ExportTo not working on deployed web app

SeSPowerBi — Mon, 29 Mar 2021 15:56:08 GMT

Solution has been found.

Re: Power BI REST API ExportTo not working on deployed web app

Anonymous — Mon, 22 Mar 2021 02:37:33 GMT

>>succeeds with a valid signature in the Bearer token and the response body is null. However, once it executes the Power Bi REST API call ExportTo it has a "404", response not found.

Have you configured your application setting to allow power bi and azure requests? If not, I'd like to suggest you take a look following document about power bi URL lists:

Add Power BI URLs to your allow list

>>The response is 204, no content. So, the server is sucessfully processed the request but it is not returning any content.

AFAIK, the 'service principal' credential has been limited to used with power bi service rest API. Have you enabled it on the admin portal? In addition, please also take a look at the 'service principal' usage limitations with power bi rest API:

Embed Power BI content with service principal and an application secret#considerations-and-limitations

Regards,

Xiaoxin Sheng

Re: Power BI REST API ExportTo not working on deployed web app

Anonymous — Thu, 01 Apr 2021 09:04:22 GMT

HI @SeSPowerBi,

Can you please share the solution that you find? I think it may should help others who faced a similar scenario.🙂

Regards,

Xiaoxin Sheng

Re: Power BI REST API ExportTo not working on deployed web app

SeSPowerBi — Thu, 01 Apr 2021 14:26:55 GMT

The ExportTo documentation is for downloading the file on the server side; in the wwwroot virtual directory.

It was working on the local solution since the current directory of the app was inside the user---me drive already C:\Users\username\source\repos\app\...

Once its deployed, the server doesn't have access to the users hard drive

"Access to the path 'c:\temp' is denied."

Since I was strictly following the documentation provided here Export Power BI embedded analytics reports API - Power BI | Microsoft Docs, I forgot to check the logic and confirm.

It was a mistake on my part, as to have access to the client-side directory and functionality, the file needs to be manipulated on the client-side not the server-side.

So I had to write code to send the export content as a Blob to then be downloaded on the client side by File-saver.

Re: Power BI REST API ExportTo not working on deployed web app

Anonymous — Tue, 06 Apr 2021 07:04:40 GMT

Hi @SeSPowerBi,

Thank for your sharing, they should help users with similar situations.😊
Regards,
Xiaoxin Sheng