Column Headers

[smpa01]

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

@AlexisOlson  @ImkeF 

[wdx223_Daniel · Accepted solution]

let

src={t1},

colname=Table.ColumnNames(src{0})

in colname

[lbendlin]

colNames = Table.ColumnNames(src)

Also consider using Expression.Evaluate if you have special circumstances.