Export paginated report to excel with image

[woptastic1]

Is anyone else having issues since upgrading with exporting images since upgrading to May 2024 version on premises. When exporting to excel and opening, I get a corruption error and the repair removes the image. <removedParts><removedPart>Removed Part: Drawing shape.</removedPart> Any suggestions on how to get around this. 

[JamesAnderson_m · Accepted solution]

Issue is apparently now fixed and available to download upgraded version:

Download Microsoft Power BI Report Server - May 2024 from Official Microsoft Download Center

[woptastic1]

Installed on test server and has resolved the issue

[MediocreJoe]

This is now working for us. Microsoft claim it was an Excel issue that's been updated, but other software couldn't open these files and while the old files still don't work, newly generated files from today do now work everywhere.

[CaspianJVC]

Same issue here. Logged Unified Support request.

[JamesAnderson_m]

Power BI Cloud has been updated to create excel files that are now compatible with the new version of Excel. However, they told me that they have not fixed Power BI Report Server yet, and that they are working on it. No time frame provided. I noticed that new versions of Power BI Report server aren't released more frequently than every 3 months - so let's hope it's not that long. In the meantime, I'm taking this as a sign I need to migrate all my reports to cloud, so I'm doing that now - only 246 reports to go....

[woptastic1]

Oof yea downside they release cloud every month generally and on-prem once a quarter. What's the financial hit to move everything to the cloud, eesh.

[CaspianJVC]

Was advised today that an update will be released next week. 

[Alpesh]

same issue here too! Hope it gets fixed soon

[JamesAnderson_m]

As an update, I've raised this through our Microsoft premium support chanel - MS have confirmed it's a bug, and that they have received many tickets related to this issue. They told me it is being looked at by their product team right now.

[MediocreJoe]

Same issue here, started this week, affecting paginated reports published to Power BI Service. All works fine except an Excel file rendered either by refreshing and exporting via Fabric or also running and exporting the report via the Power BI module in Power Automate. All appears to work, but a user trying to open the file in Excel then gets the corruption error pop up. Reports with no graphs are fine, it only affects our reports with graphs. Other file formats not affected, e.g. PDF and MHTML. Viewing reports in Report Builder or Fabric is also fine, as is exporting to XLSX from Report Builder - it's the Excel output from the web that's the issue.

[Wdenegri]

same error here just after upgrade to may 2024 version. 

[BPI]

Same problem here - reports previously worked fine, can export from Report Builder without issue, but Exporting to Excel in the Service I get the same error re: images.

[justinkyalo]

We seem to have the same problem. Last month it was ok. Export to xl causes "repairs" that seem to remove charts.

[JamesAnderson_m]

Yeh I'm having this issue as well now, both on the local power bi report server, and the cloud report server.

[baduncle]

I've got the same problem since upgrading to Power BI Report Server Version May 2024.

When exporting a paginated report to excel, it can't display images.

With other data types it works just like before.

[Anonymous]

Hi @woptastic1 ,

Has this problem happened before? Or is this the first time it's happened?

I test it in Microsoft Report Builder, it works well.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MediocreJoe]

Steps to reproduce the issue as we've seen it:

1. Published paginated report (.rdl) containing a graph required to be published in a Power BI Premium Per User workspace. This can be an existing published report, or a new one created from scratch

2. (Optional) Create paginated report & publish

a. Open Power BI Report Builder

b. Select New Report, Blank Report

c. Right click Data Sources, Add Data Source, enter details for a Microsoft SQL Server data source

d. Test connection and click OK

e. Right click Datasets, Add Dataset, select the Data Source just created

f. Enter the query to run (to return something that can be put in a graph) and click OK

g. In the top menu, select Insert, Chart, Insert Chart

h. Click in the report to add a chart, select the required chart type and click OK

i. Select the chart and add Values, Category Groups as required

j. Click Run to test the report runs OK and the graph displays information

k. Click Export and select Excel at this point to show that the Excel output is rendered OK from Report Builder

l. In the top menu select File, Publish, Power BI Service

m. In the "Publish to - Power BI Service" window, select the workspace, enter a report name, click Publish (in our case this is Premium Per User)

3. Open the report in https://app.powerbi.com/

4. The report should refresh and display with no issues

5. Select Export in the top left, then Microsoft Excel (.xlsx)

6. Attempt to open the downloaded .xlsx file and the pop up is displayed:

We found a problem with some content in 'Report name here.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

7. Clicking Yes opens the file with some or all content removed

8. Separately, the same outcome is arrived at if at step 3, instead of opening the report via Power BI, Power Automate is used with the "Export To File for Paginated Reports" module refreshing the report and passing it on to a "Send an email from a shared mailbox (V2)" module

[MarkSL]

Same issue here.  Standard Paginated Reports are not exporting to Excel without error if they contain images or charts.

Hope this is fixed very soon!

[JamesAnderson_m]

I just tested this by creating a simple paginated report, with one SQL database connection, pulling back a two column table with Date and value - I then made a simple line chart and published this file to Power BI Cloud Server premium workspace. If I run that report on the server, it renders on screen, but when I download to Excel, when I open it, it says that it's corrupt, if you click repair, it removed the drawing shape (which in this case is the line chart). This issue is a critical issue and needs urgent support. I have personally raised a ticket with Microsoft on this.

[woptastic1]

Hey @Anonymous yeah this is the first time it's happened and began after upgrading to May 2024. The rdl file rendered in visual studio will export the image just fine however once you upload it to Power BI report server and export it, excel says it's corrupt and removes the image.