Forum Discussion
Where Report Server stores uploaded .pbix files?
Resolver IIHello
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
- ForcaTaico
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
See that's what happens when you keep using the old cmdlets and not reading the release notes! I hadn't even looked at the REST cmdlets.
That is going to make my life a whole heap simpler!
Many thanks