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,479 Super User 2025 Season 2 on at

Like (0)

Report

Are you trying to Base64 encode the file twice?

Was this reply helpful? Yes No
felipecanhetti 4 on at

Like (0)

Report

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,479 Super User 2025 Season 2 on at

Like (0)

Report

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

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

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

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

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

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

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