Unanswered

Error in the Exported PowerBI file (corrupted file)

(0) Share

Report

Posted on by felipecanhetti

Hello dear community!

I created a flow to "Export a File For PowerBI Report" and then e-mail the file. An Error occurs when opening the Exported file generated by PowerAutomate saying the file is corrupted and cannot be opened. I tried to select PDF and PPTX file from the PowerBI extraction and I also guaranteed to write the extension in the file name I send from the email.

Does anyone know how to solve this problem?

My flow:

My configurations:

Thanks in advance for all the good souls active in

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (0)

lbendlin 8,598 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Are you trying to Base64 encode the file twice?

Was this reply helpful? Yes No
felipecanhetti 4 on at

Like (0)

Report
Copy link

Link copied!

No, this "Base64" appeared after I saved the flow. Before saving, the text was like this:
The codes that appear are:
* BI Export:
"
{
"type": "OpenApiConnection",
"inputs": {
"parameters": {
"groupid": "myworkspace",
"reportid": "70417e0a-1bf8-4488-b0cd-16f7ad6617f5",
"ExportPayloadPowerBIReport/format": "PDF"
},
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_powerbi",
"connection": "shared_powerbi",
"operationId": "InitiateExportToFileForPbiReports"
}
},
"runAfter": {}
} "

* Code the Email part:
"
{
"type": "OpenApiConnection",
"inputs": {
"parameters": {
"emailMessage/To": "felipe.oliveirac@kof.com.mx",
"emailMessage/Subject": "TEste PBI",
"emailMessage/Body": "<p>teste</p>",
"emailMessage/Attachments": [
{
"Name": "Teste BI.PDF",
"ContentBytes": "@{base64(body('Exportação_para_Arquivo_para_Relatórios_do_Power_BI'))}"
}
],
"emailMessage/Importance": "Normal"
},
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_office365",
"connection": "shared_office365",
"operationId": "SendEmailV2"
}
},
"runAfter": {
"Exportação_para_Arquivo_para_Relatórios_do_Power_BI": [
"Succeeded"
]
}
}"

It seems like its only Base64 encoding once

Was this reply helpful? Yes No
lbendlin 8,598 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

How large is the attachment? Base64 strings have a low size limit.

Was this reply helpful? Yes No
felipecanhetti 4 on at

Like (0)

Report
Copy link

Link copied!

It should be a small attachment since it is only a one-page report from PowerBI.
Where can I see the size of the file generated by the "Export from PowerBI" automation? (I tried downloading it, but it was saved as a JSON and I could not open that)

The error I receive from Adobe Reader is:

Was this reply helpful? Yes No
LukasG 8 on at

Like (0)

Report
Copy link

Link copied!

I have exactly the same issue and error message (also tried PPT but also says the file is corrupt) - would love if someone had a solution for this!

The exports work fine when I do them directly from the PowerBI report...

Was this reply helpful? Yes No
XYZUser 30 on at

Like (1)

Report
Copy link

Link copied!

Hi,
This seems to be a bug in power automate new designer. I was also facing this issue earlier.
If you go back to the old designer (by disabling the new designer toggle present in top-right), then it'll surely work fine.

Was this reply helpful? Yes No
LukasG 8 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much @XYZUser that was the right solution 😄

Although it was not enough to just hit the toggle, I also had to reselect the output from the PowerBI step in my email step for it to work. But now it works!

Was this reply helpful? Yes No
XYZUser 30 on at

Like (2)

Report
Copy link

Link copied!

Yess, Forgot to mention that you need to reselect the power bi content file again in your email step 🙂

Was this reply helpful? Yes No
tech2188_ATSG 3 on at

Like (0)

Report
Copy link

Link copied!

Thank you all. Had the same issue and this fixed it. Reselecting was a critical part of the equation.

Was this reply helpful? Yes No