Optimize Power BI Dataset

[abhiram342]

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

[ppm1 · Accepted solution]

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