When Importing data on PBIX , where is the data stored?

[dpombal]

Hi all, 

When publishing a report PBIX to on premise PowerBI Report Server, Where is the info stored?

On

• Machine with PowerBI Report Server
• Inside ReportServer and ReportServerTemp Catalog Databases?

Is there a PBIX file limit for Import using Powerbi Report Server 

Regards

[Anonymous]

A copy of the PBIX seems to be stored in the dbo.Catalog table in the Content column.

If you find a PBIX file in here get its ItemID (GUID)

This is split out into a number of rows within the dbo.CatalogItemExtendedContent table. 

If you query this table with the ItemID of your PBIX you will see two or three rows with content types of

CatalogItem
PowerBIReportDefinition
DataModel

The DataModel row seems to be the elemnt that gets updated by any scheduled refresh.

Most of our data models are tens of Mb so I can't really speak to how it scales. For our bigger data sets we use a SSAS Tabular model and a live connection. Those guys scale up to tens of Gb.

There is a config/property on the server called MaxFileSizeMb which is currently set to 1000. I think this is probably used during upload/submission but the data blob could theoretically get bigger than this in the DB.

[dpombal]

Thanks, will to monitor and limit the number of snapshots report stores (PBIX file is 150 MB size) and having 4/5 copies in enough for me