Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Olenard
Helper III
Helper III

ALM toolkit - power query

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

1 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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

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?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi @GilbertQ ,

 

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

Olenard_0-1599563617833.png

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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

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

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.