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

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!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi Anonymous, I've installed a whole new server and new database. When start testing, face same problem! For some reports I could save them, even in a several times, rewriting then. For others, the most, same problem, mainly when I try to re-write it.

  • manceelee's avatar
    manceelee
    Frequent Visitor
    8 years ago

    I tried once, uninstall the current report server -> restore the key -> use old existing repot server database -> failed to load previous report 

     

    I have to create a new report server database and upload all reports again, please let me know if I miss anything to recover this.

     

    Thanks!