Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

 

Any clue how to address this issue.

Help
Need Help

5 Replies

  • saglamtimur's avatar
    saglamtimur
    Icon for Resolver II rankResolver II
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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?