Search code examples
sql-serverpowerbi-desktoppower-bi-report-server

Save as Power BI Report Server for publish


I tried to publish a report with SSRS BI.

I used Power BI desktop May 2019 and Report server ver 15.0.1104.310

  1. IE run with run as administrator
  2. Power BI run with run as administrator
  3. Reporting Server Configuration run with run as administrator
  4. Set Web service URL
  5. Set database and test it
  6. Set web portal URL
  7. Generate a report in Power BI Desktop and save it in a folder
  8. now I tried to save as report by portal URL but catch error :

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

enter image description here

Set new report server http://reporting-power/ReportsPBI this link work well on IE

When save as this report ask a question for set file name I set Test.pbix and click on OK button. save process start and shown above error message.

Also I tried to create a new folder on Power BI Report server and save as report on this folder, and again received above error again.

I search problem and just find this link for SSRS 2016 does not support publishing power bi reports locally but I used 2019 and received same error.


Solution

  • should be change service account. I set use built-in account. But the service account used in Report server Configuration Manager was not a local admin.

    With a user that is a local administrator on the server, we were able to get PBI Reports working on PBIRS. enter image description here