Power Bi : Dynamically Set Column Names for Merged Tables

Power Bi : Dynamically Set Column Names for Merged Tables

1.180 Lượt nghe
Power Bi : Dynamically Set Column Names for Merged Tables
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