cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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 7
Highlighted
Microsoft
Microsoft

Re: Where Report Server stores uploaded .pbix files?

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.

Highlighted
Helper III
Helper III

Re: Where Report Server stores uploaded .pbix files?

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!

Highlighted
Impactful Individual
Impactful Individual

Re: Where Report Server stores uploaded .pbix files?

Highlighted
Resolver II
Resolver II

Re: Where Report Server stores uploaded .pbix files?

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

Highlighted
Impactful Individual
Impactful Individual

Re: Where Report Server stores uploaded .pbix files?

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

 

 

 

Highlighted
Resolver II
Resolver II

Re: Where Report Server stores uploaded .pbix files?

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

 

 

Highlighted
Impactful Individual
Impactful Individual

Re: Where Report Server stores uploaded .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!

 

Many thanks

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors