Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Cannot Publish Power BI Report

We have a dev, test, and production environment for Power BI Report Server.  The dev and test environment are setup on stand alone servers with both front end web server and back end SQL database on ...
power bi
Power BI Desktop
Power BI OnPrem Server
Power BI Report Server
  • Anonymous's avatar
    Anonymous
    8 years ago

    All -

     

    I finally unistalled everything (even dropping the reportserver and tempreportesrver databases), and re-installed fresh.  This seemed to resolve the issue as I am now able to publish Power BI reports either via the "Save as" option or uploading from the Power BI portal.

     

    To uninstall simply run the setup and choose the ininstall option.  Finish up by using SSMS to drop the associated databases.

     

    I'm assuming this happened after updating Power BI from one version to another.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Anonymous, what about the previously reports? did you restored them? How? restoring the databases? Here we have a several objects / reports.

 

Tks

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hey Anonymous -

I was kind of lucky and didn't have too many reports to re-publish, about 15 or so.  We keep the pbix files on a secure network share, but plan on implementing some kind of TFS solution soon.

 

I needed everything up and running ASAP so I just wiped everything out and re-published.  You can try just uninstalling Power BI, and keeping the the databases, just reconnect to an already existing database when going through configuration manager.

 

Alternatively the back up / restore process is pretty much identical to SSRS if you've worked with that in the past.  If not, here you go:

 

https://community.powerbi.com/t5/Report-Server/report-server-backup/td-p/366579

 

Good luck!