Forum Discussion
Dataset Refresh Failure in PowerBI Service
You have hit a hard limit. 10 GB. HOWEVER - this is not a limit of the semantic model, nor is it the limit for a table. It is the limit for a PARTITION.
Solution: Switch to incremental refresh and make sure each partition stays under 10 GB.
Thank you so much lbendlin for your quick response and each partition data is below 1GB when i loaded into separate .pbix files but i have a large fact table which has 120M rows along with 130 columns to be loaded and it's corssed 10GB as of now overall .pbix file is around 10.6GB.
But i pulled only 1year data and published and with the help of tabuler editor connected to my model and created quarterly partitions like 16 partitions for 4 years and trying to load the data and it's not allowing me to load the data hence it's giving the error like we exceeded the limt of 10240MB.
in our case incremental refresh will not work as our historical data also changes and users needed full load on daily basis. please suggest us if anyone came across to this situation. Thanks
You can still use incremental refresh - just need to manually refresh the individual historic partitions when you have data changes. This can be done via the Enhanced Refresh API.
Also read about bootstrapping. Advanced incremental refresh and real-time data with the XMLA endpoint in Power BI - Power BI | Microsoft Learn