Excel rendering is not working on PowerBI report server

[Anonymous]

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.

Any clue how to address this issue.

[saglamtimur]

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]

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?

[saglamtimur]

No news at the moment.

[Anonymous]

@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]

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)