Forum Discussion
Changing data type and the need to reload
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?
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,
3 Replies
- ibarrau
Super User
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,
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