Export to excel for paginated reports using power bi API gives corrupt file

[Anonymous]

I am trying to call https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getfileofexporttofileingroup Power BI API using azure function to get the file export in excel for paginated reports. I am calling the API using powershell, it works and response is generated.

I am using this output in logic apps to create excel report in one drive. The report gets created but while opening the excel it gives error "File is corrupt or invalid file".

Also i observed the content length from the azure function is different than direct API call using fiddler (content lenght from azure function is more).

Any suggestions how to fix the export to excel ? And why there is difference in content length?

[v-lionel-msft]

Hi @Anonymous ,

In other words, the exported file obtained through this API cannot be opened?

Maybe you can refer to the link.

c# - Angular/Web API 2 returns invalid or corrupt file with StreamContent or ByteArrayContent - Stack Overflow

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.