Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
let
// manuallly building src
//contains name of each pq table (opposed to dax derived table)
//starting with a single element for the sample
src={"t1"}, //t1 is the name of a pq table
//need to get the column names
colNames = Table.ColumnNames(src{0}) //errors out
in
colNames
I am trying the above and it is failing. If it can work, I can loop through all table names.
I am aware DAX can get the colNames for all tables in a DB; But I am looking for a PQ solution.
Thank you in advance
Solved! Go to Solution.
let
src={t1},
colname=Table.ColumnNames(src{0})
in colname
colNames = Table.ColumnNames(src)
Also consider using Expression.Evaluate if you have special circumstances.