0:00 Start
0:22 Tables from SQL and Excel
1:00 Merging Tables
1:35 Expanding Columns
2:04 The Problem
3:14 Manual Solution
3:47 Dynamic Solution
7:44 The Results
9:16 Dashboard Example
Oftentimes when merging different data sources, the column names are hard coded. This prevents Power Bi from capturing new data when additional columns are added to the source. In this video, I will show you how to dynamically capture the column names from the original data source and pass them to your final merged data.
************************
Equipment Used
************************
Camera: https://amzn.to/3lNAi2L
Microphone: https://amzn.to/2YUu34j
Mic Windscreen: https://amzn.to/3lRdOhi
Mouse and Keyboard: https://amzn.to/3jbR3TM
Monitor Screen: https://amzn.to/3vkQcF6