Changing data type and the need to reload

[RandyPgh]

I have a large dataset deployed with a partitioned table. If I want to change some Decimal columns to Fixed Decimal, can I simply use ALM Toolkit to deploy the change, or will I then need to reload all the partitions?

[RandyPgh]

@ibarrau thanks for the reply. If ALM will deploy the change, do you know if a data type change like this will require a data reload?

[ibarrau]

I'm pretty sure you need the data reload because it's a power query change. The changes for DAX that run after the model is built won't need. However in your case the data type change represents a new line code in the Power Query lines. In order to make those change, data must be refreshed.

Regards

[ibarrau · Accepted solution]

Hi. As far as I knew I thought ALM Toolkit would only help you with DAX. However some time ago I have found this comment deploying power query stuff. I think you can with the tool.

https://community.powerbi.com/t5/Developer/ALM-toolkit-power-query/m-p/1346648

I hope that helps,