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...
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.