ALM toolkit - power query

[Olenard]

dear colleagues,

trying to use ALM toolkit to deploy Azure Analysis services database, I realized each time there is a change in power query, the change is not deployed.

ie: if I create a new column in power query on a table, when processing the model deployed with ALM, there is an error message mentioning the column source is not found, and looking at the code itself, indeed the power query code has not changed after deploying.

do you know why ? Is it a limitation, an error from mine in parameters

[GilbertQ]

Hi there

Can you go into the Options in the ALM Toolkit and make sure that you have enabled the option to check on tables for changes?

[Olenard]

Hi @GilbertQ ,

thanks for your feedback. I think i did. Do you have any comment on the current options settings : 

[GilbertQ · Accepted solution]

Hi there

Remove the tick under "For table updates, retain partitions" and "For table updates, retain storage mode"

That should allow the changes to be shown

T

[rishirajdeb]

Please be aware of not doing it for a model in which incremental refresh is implemented, as this will remove the partitions.

[Olenard]

Great, I will try very quickly and confirm if this is ok!!