Forum Discussion
Reduce dataset size Options - Large datasets format -mixed mode, hybrid tables
Hi , I have a "large dataset" formatted dataset that is apprx 10 gb and growing which is hitting memory constraints even with incremental refresh enabled on a P1 SKU on a import model. I am ...
Hi AnandGNR,
In fact, direct query not suitable to handle that stores large amount of records. They will exceed to the limit when use table fields on visual.
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn
I'd like to suggest you split these records to two dataset and one used to store these historical data and you create a report with multiple datasets.
Regards,
Xiaoxin Sheng