Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago
Solved

Column Headers

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 

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion

    let

    src={t1},

    colname=Table.ColumnNames(src{0})

    in colname

  • colNames = Table.ColumnNames(src)

     

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