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?
This other thread may be helpful
You can use Powershell to download content from the reportserver.
Look at the function "Out-RsRestFolderContent"
Out-RsRestFolderContent -Destination C:\REPORTS -RsFolder / -Recurse -ReportPortalUri http://URL/reports
The above Powershell will download all the content from reportserver to C:\REPORTS
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
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.
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!
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.