Forum Discussion
Suggestion on Large Data Model
Thanks lbendlin, that is already in consideration but the cost is too high for the upgrade.
Is there any best way on reducing this? does removing some measures, functionalities (like dropdown switch of measure), visuals, calculated columns and reducing data modelling within power query will help it?
I have looked all over the place but can't seem to fit to what I am experiencing at the moment.
Measures play no role in dataset size.
Consider using partitions. Basically incremental refresh but controlled manually. That way you can refresh smaller parts of the dataset one at a time.
Calculated column does right?
Do you have any documentation or similar case/topic that shows how partitions work? Thank you very much.
yes, Calculated Columns do. Use DAX Studio to identify the columns that contribute most.
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn
