Not all Datasets you'll receive will enable you to just use the first row of data as a table header without any hard coding. In this video i demonstrate how you can dynamically set your Query Header Titles - using some really awesome Power Query functions.
#powerbi #powerquery #mquery #m #dataanalytics #data
Links
Table.ColumnNames
https://learn.microsoft.com/en-us/powerquery-m/table-columnnames
List.PositionOf
https://learn.microsoft.com/en-us/powerquery-m/list-positionof
List.FirstN
https://learn.microsoft.com/en-us/powerquery-m/list-firstn
Record.ToList
https://learn.microsoft.com/en-us/powerquery-m/record-tolist
List.Zip
https://learn.microsoft.com/en-us/powerquery-m/list-zip
Table.RenameColumns
https://learn.microsoft.com/en-us/powerquery-m/table-renamecolumns
my site
https://www.basensei.com