Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Where Report Server stores uploaded .pbix files?

Hello, 

 

Where Report Server stores uploaded .pbix files? 

I'm using Microsoft Power BI Desktop (Optimized for Power BI Report Server - March 2018) and Microsoft Power BI Report Server - March 2018, When I create a report, I driectrly upload it to the the server.

My Question is where these reports (.pbix) are stored and is it possible to copy/backup up them?

Server

7 Replies

  • Jon-Heide's avatar
    Jon-Heide
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    They are stored in the server SQL database configured for the server, known as the "catalog". You can use SQL backup capabilities for disaster recovery.

  • ForcaTaico's avatar
    ForcaTaico
    Icon for Resolver II rankResolver II
    8 years ago

    Hello

     

    You can use Powershell to download content from the reportserver.

     

    https://github.com/Microsoft/ReportingServicesTools

    Look at the function "Out-RsRestFolderContent"

     

    Fx: 

    Out-RsRestFolderContent -Destination C:\REPORTS -RsFolder / -Recurse -ReportPortalUri http://URL/reports

     

    The above Powershell will download all the content from reportserver to C:\REPORTS

     

    Regards Taico

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Those PowerShell tools do export content from a regular SSRS Srever

       

      the syntax is

       

      Out-RSFolderContent -ReportServerUri 'http://yourserver/Reports' -RsFolder / -Recurse -Destination C:\Somewhere

       

      However this does not seem to download any PBIX files. At least not when I have used them (I have been using them for some time on regular SSSR instances)

       

      I have looked through the library/module and spotted what looks like support for PBIX files. But have not yet figured out how to actually get PBIX files out. I did think it was being skipped in the Out-RSFolderContent.ps1 as it only exports certain contentTypes. But after adding PBIReport as an allowed type it seemed to make no actual difference.

       

      Hence I resorted to a brute force DB approach and extracted directly from the DB