topic Re: ALM toolkit - power query in Developer

ALM toolkit - power query

Olenard — Fri, 04 Sep 2020 07:38:41 GMT

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

Re: ALM toolkit - power query

GilbertQ — Sun, 06 Sep 2020 23:51:01 GMT

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?

Re: ALM toolkit - power query

Olenard — Tue, 08 Sep 2020 11:14:30 GMT

Hi @GilbertQ ,

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

Re: ALM toolkit - power query

GilbertQ — Wed, 09 Sep 2020 00:33:41 GMT

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

Re: ALM toolkit - power query

Olenard — Thu, 10 Sep 2020 09:31:59 GMT

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

Re: ALM toolkit - power query

rishirajdeb — Thu, 10 Mar 2022 17:01:43 GMT

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