Forum Discussion

biuser98's avatar
biuser98
Helper II
3 years ago
Solved

ALM Toolkit not detecting changes in Power Query

Hi,   I am using ALM Toolkit to update my dataset in the service without re-publishing from desktop.  I changed the code of the source of my table in the power query steps. When I compare the data...
Need Help
  • dgwilson's avatar
    dgwilson
    2 years ago

    My updated understanding is that under options, you should have "Consider partitions when comparing table" checked (ON).

dgwilson's avatar
dgwilson
Resolver III
2 years ago

Hi there...

 

I've just encountered the same issue you have reported.
I needed to change the M code (added a filtering step, and a remove duplicates step) and ALMToolkit doesn't pickup the M code change.... perhaps my mystake is I thought it would.

To diagnose:

I have duplicated an existing column and ALM correctly picks this up as a change... i.e. it wants to change the database definition in the cloud.

 

I thought, perhaps wrongly, that it did pick up M code changes.

For reference ALMToolkit version is 5.0.44

biuser98's avatar
biuser98
Helper II
2 years ago

Hi , same here, the m code wont detect any changes.

  • dgwilson's avatar
    dgwilson
    Resolver III
    2 years ago

    My updated understanding is that under options, you should have "Consider partitions when comparing table" checked (ON).

    • biuser98's avatar
      biuser98
      Helper II
      2 years ago

      This seems to work. Could you explain?

      • dgwilson's avatar
        dgwilson
        Resolver III
        2 years ago

         

        > This seems to work. Could you explain?

         

        The technical answer from support is:

        "M expressions for tables are represented as partition objects, so if you want to see them and have them considered for comparison, you need that checked.".

         

        - David