Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
When publishing a report PBIX to on premise PowerBI Report Server, Where is the info stored?
On
Is there a PBIX file limit for Import using Powerbi Report Server
Regards
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.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
15 | |
9 | |
6 | |
3 | |
3 |