When publishing a report PBIX to on premise PowerBI Report Server, Where is the info stored?
Is there a PBIX file limit for Import using Powerbi Report Server
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
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.