Forum Discussion
abhiram342
Microsoft Employee
Microsoft EmployeeOptimize Power BI Dataset
Hi Team, We have Power BI Dataset model with sales data and Sales amount occupies 60% of size. Is there way to optimize it? Sales Amount is double datatype in power bi dataset. We can't case to ...
You can change it to fixed decimal, which should give plenty of precision and significantly reduce the column/table size. Also delete any unneeded columns in the model, especially any others with high cardinality (datetime or double type). And make sure Auto Date/Time is unchecked in the options.
Pat
ppm1
Solution Sage
Solution SageYou can change it to fixed decimal, which should give plenty of precision and significantly reduce the column/table size. Also delete any unneeded columns in the model, especially any others with high cardinality (datetime or double type). And make sure Auto Date/Time is unchecked in the options.
Pat