Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
MP2
Regular Visitor

How is data stored in Report Server between scheduled refreshes?

I'm looking at the data security of Report Server. I need to know how data is stored between data refreshes. For example, if I schedule a nightly data refresh, where will the data be stored in the 24 hours between refreshes?

Presumably the data must be stored in the Report Server environment somewhere, I just can't find any documentation on whether this is in the .pbix file that's been uploaded to Report Server, or in the Report Server database tables. Is the data encrypted?

I need to be able to assess the risk that someone could gain access to the Report Server backend and see data that they shouldn't.

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @MP2 ,

 

I found someone explained in more detail:


When you upload a PBIX file to PBI-SSSR Server it creates an entry in the ReportServer DB dbo.catalog. It also creates two entries in dbo.CatalogItemExtendedContent table. One of these is the visuals, m code etc, the other is the data blob.

 

If you take a PBIX that has imported data and rename it to .zip you can Unzip it. Inside you will find a file called DataModel. This is a super compressed blob of data. This is the thing that gets split out. Everything else is in the visuals blob.

 

I assume this is so that you can setup a scheduled refresh of the data and it just overwrites the data blob.

 

When you view a PBIX report the SSRS server magically stitches them back together somehow. Actually what it looks like it does is fire up a captive instance of SSAS tabular and feeds it the data blob. Your visuals are then connected to this temporary data source and as you slice and dice your charts the queries are sent to the captive SSAS instance. Once you've spun your report down the captive SSAS instance is quietly killed off.

 

Reference: PBIRS reports dataset stored


 

 

Best regards

Icey

 

If this post helps,then consider Accepting it as the solution to help other members find it faster.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @MP2 ,

 

I found someone explained in more detail:


When you upload a PBIX file to PBI-SSSR Server it creates an entry in the ReportServer DB dbo.catalog. It also creates two entries in dbo.CatalogItemExtendedContent table. One of these is the visuals, m code etc, the other is the data blob.

 

If you take a PBIX that has imported data and rename it to .zip you can Unzip it. Inside you will find a file called DataModel. This is a super compressed blob of data. This is the thing that gets split out. Everything else is in the visuals blob.

 

I assume this is so that you can setup a scheduled refresh of the data and it just overwrites the data blob.

 

When you view a PBIX report the SSRS server magically stitches them back together somehow. Actually what it looks like it does is fire up a captive instance of SSAS tabular and feeds it the data blob. Your visuals are then connected to this temporary data source and as you slice and dice your charts the queries are sent to the captive SSAS instance. Once you've spun your report down the captive SSAS instance is quietly killed off.

 

Reference: PBIRS reports dataset stored


 

 

Best regards

Icey

 

If this post helps,then consider Accepting it as the solution to help other members find it faster.

FarhanAhmed
Community Champion
Community Champion

I think report data stored in ReportServer DB where it is hosted. 

you can take a look into the table "[dbo].[CatalogItemExtendedContent]" under Report Server DB .

 

The data seems encrypted but you can explore a bit more







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.