cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ultrashock Regular Visitor
Regular Visitor

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
Jon-Heide Established Member
Established Member

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.

ultrashock Regular Visitor
Regular Visitor

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!

stpnet Established Member
Established Member

Re: Where Report Server stores uploaded .pbix files?

ForcaTaico Member
Member

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

stpnet Established Member
Established Member

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

 

 

 

ForcaTaico Member
Member

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

 

 

stpnet Established Member
Established Member

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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 253 members 2,741 guests
Please welcome our newest community members: