Forum Discussion
Export paginated report to excel with image
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.
Issue is apparently now fixed and available to download upgraded version:
Download Microsoft Power BI Report Server - May 2024 from Official Microsoft Download Center
20 Replies
- JamesAnderson_m
Advocate I
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
Advocate I
Installed on test server and has resolved the issue
- MediocreJoeFrequent Visitor
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.
- CaspianJVCNew Member
Same issue here. Logged Unified Support request.
- JamesAnderson_m
Advocate I
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
Advocate I
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.
- Alpesh
Helper I
same issue here too! Hope it gets fixed soon
- JamesAnderson_m
Advocate I
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.
- MediocreJoeFrequent Visitor
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.
- WdenegriNew Member
same error here just after upgrade to may 2024 version.
- BPIFrequent Visitor
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.
- AnonymousNot applicable
We seem to have the same problem. Last month it was ok. Export to xl causes "repairs" that seem to remove charts.
- JamesAnderson_m
Advocate I
Yeh I'm having this issue as well now, both on the local power bi report server, and the cloud report server.