Forum Discussion
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?
7 Replies
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.
This other thread may be helpful
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
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
Hi again
I think is a new feature:
"- v2.0 of REST Endpoint is supported by Microsoft and is for SSRS 2017, PBIRS October 2017 and newer releases."
But it does indeed download the pbix files.
Regards Taico
