List of columns in a table

Power BI
1

hello,
how is it possible to get a list of the columns in a table?
thanks

2

Are you talking about in Power Query? If so, this is a query I created (a little bit grand to say that when it is one line of code :rofl: ) to give me a list of my Date table column names

let
    Source = Table.ColumnNames(Date)
in
    Source

image
image370×654 14.1 KB

2 Likes
3

In a report I would like to show the list of columns of a table

1 Like
4

You could convert the list I’ve created to a table and it will be included in your report, you could then drop the field into a table visual.

1 Like
5

@arkiboys,

How and why?

From my perspective @DavieJoe perfectly answered your question. From your response I can only make out that there seems to be ‘far’ more to it than you’ve shared right now… Therefore I would suggest you close this thread out by marking DavieJoe 's response as answer and give some thought before creating a new thread. Thanks!

2 Likes