Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.