When Appending Data sets one often lands in trouble when source table columns change or are added or removed. Usually you'll have to edit your Queries, In this video i show you how to Dynamically Expand appended datasets in Power Query so that you'll always have the latest data structure upon refresh.
#powerquery #powerbi #powerbidesktop #dataanalytics #data #mquery #m #excel #exceltutorial #exceltips
Links
https://basensei.com/software/powerbi/power-query-dynamic-merge-expansion/
Video 1
https://youtu.be/PVo5z0H8TpE