Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
smpa01
Super User
Super User

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 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 ACCEPTED SOLUTION
wdx223_Daniel
Super User
Super User

let

src={t1},

colname=Table.ColumnNames(src{0})

in colname

View solution in original post

2 REPLIES 2
wdx223_Daniel
Super User
Super User

let

src={t1},

colname=Table.ColumnNames(src{0})

in colname

lbendlin
Super User
Super User

colNames = Table.ColumnNames(src)

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors