Forum Discussion
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 int because it's sales data adn we preseve the precision from source.
In SQL, the salesamount datatype is defined as float.
Thanks,
Abhiram
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
1 Reply
ppm1Solution Sage
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