Forum Discussion
Semantic model - maximum size limit on disk
How is the below error message related to the fabric capacity?
My model is a direkt lake only. Is this error related to the SKU limitation Max memory GB?
I thought it this limitation was related to direct query models.
Database exceeds the maximum size limit on disk; the size of the database to be loaded or committed is bytes, and the valid size limit is bytes. If using Power BI Premium, the maximum DB size is defined by the customer SKU size (hard limit) and the max dataset size from the Capacity Settings page in the Power BI Portal.
3 Replies
joakimfenno Have you tried enabling this Semantic model setting ? Not sure if this will help
Thanks,
Jai
yes but it will not help
In my case the dataset was exceeding the 1 GB limit because I was loading intermediate tables into the model that were only used as sources for other tables (Append / staging queries).
Even though those tables were not used in any visuals or relationships, they were still physically loaded into the model, effectively duplicating the data and increasing the dataset size.
The fix was to disable load for those intermediate/staging tables in Power Query and keep load enabled only for the final tables that are actually used in the model.
After disabling load on the source tables and refreshing, the dataset size dropped below the limit and the publish/refresh completed successfully.
