Where Report Server stores uploaded .pbix files?

[Anonymous]

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?

[ForcaTaico]

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]

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."

https://github.com/Microsoft/ReportingServicesTools/blob/master/ReportingServicesTools/Functions/Cat...

But it does indeed download the pbix files.

Regards Taico

[Anonymous]

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

[Jon-Heide]

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.

[Anonymous]

Can you please explain a little bit more detailed how wxactly to recover the report files - .pbix? from the MS SQL?

 I'm using MS SQL 2012.

Thanks in advance!

[Anonymous]

This other thread may be helpful

https://community.powerbi.com/t5/Report-Server/Where-Can-I-find-the-published-report-in-PowerBI-Serv...