Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
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.
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.
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.
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)
User | Count |
---|---|
4 | |
4 | |
1 | |
1 | |
1 |
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 |