Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Excel rendering is not working on PowerBI report server

I have just migrated all my reports from SSRS to newly configured PowerBI report server.

The reports are running without any issues but While performing excel rendering, I am getting below error message.

 

Sandeep3596_0-1593028208528.png

Any clue how to address this issue.

5 REPLIES 5
saglamtimur
Resolver II
Resolver II

Try editing the rsreportserver.config file and change these lines:

 

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="true"/>
<Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>

It's a known bug. Basically, by doing this, you are configuring PowerBI report server for exporting to XLS insted of XLSX. Same goes for Word. You can handle it until the problem is solved by Microsoft.

Anonymous
Not applicable

Thanks for sharing the solution.

After changing the config file now I started seeing Excel 2003 as a rendering option and its working fine.

 

Is there any official announcement from Microsoft about this Excel rendering issue in PowerBI report server?

 

 

No news at the moment.

Anonymous
Not applicable

@saglamtimur 

we tried to configure Developer Edition on a test server and Excel rendering working without any issues

 

When we tried to configure Report server in Production server with PowerBI report server Key and followed same steps and we started seeing Excel rendering issues.

 

Both Test Prod server are from same build with no differences in any tools installed.

 

Not sure what made the difference between Developer version to production version.

Anonymous
Not applicable

Here is how we made excel rendering work at last

Step1: INstall PBI report server as Developer edition in Production

Step2: Upgrade from Developer to Premium and Excel is working in Premium license.(you can upgrade option by navigating to control panel and uninstall a program and double click on PBI report server and you will be prompted with Unistall, Repair and Upgrade)

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.