CODEWITHSUNDEEP
sql-serverreporting-servicespowerbi
tonyyeb
tonyyeb

Reputation: 719

Cannot publish Power BI report to local Report Server

We have just installed a local instance of the Power BI report server on our SSRS 2016 server.

It runs fine, can browse the directories via a browser. But when trying to publish from the desktop application we get the error:

an error occurred while attempting to save the report to power bi report server.

If trying to upload a .pbix file through a web browser we get this error "There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file".

The suggestion when searching says the Service Account being used (set via the Report Server Configuration Manager) must have local admin rights and rights to the database. I have tried several ways of doing this and still nothing works.

Upvotes: 5

Views: 13480

Answers (2)

Alexander Volok
Alexander Volok

Reputation: 5940

SSRS 2016 does not support publishing power bi reports locally.

You have to upgrade your SSRS instance to SSRS 2017

It also comes as a separated install package now.

Link for download: Microsoft SQL Server 2017 Reporting Services

Update by @taterhead:

Power BI files to be uploaded by a custom Power BI Desktop that matches Power BI Report Server: Install Power BI Desktop optimized for Power BI Report Server

Upvotes: 4

Taterhead
Taterhead

Reputation: 5951

I recommend you use Power Bi Desktop Optimized for Power Bi Report Server (yes its a separate client). The release of this client coincides with the release of Power Bi Report Server. Both were recently released in March 2018. Before that, the previous release was October 2017.

Try opening your report inside of this Power Bi Desktop Optimized for Power Bi Report Server, ensure your report is working according to your requirements and then save, and upload this file to Report Server. There are some limitations on reports that are released to Report Server that you need to consider (no R Visuals, ARCGIS Maps, and others.). But most of the functionality will work on Report Server.

This thread has a user with the same error as yours, and using the Power Bi Desktop Optimized for Report Server solved the problem for that user.

Upvotes: 2

Related Questions