How to extract column names from a table

Question

Hi All&nbsp;I have imported a SQL Server table. I want to get the column names of that table. Have gone thru the below link and tried the solution specified. The solution lists the table name and column names, but the values are not persistent. Cannot use that in report.&nbsp;https://community.powerbi.com/t5/Power-Query/Getting-a-list-of-all-columns-in-all-tables-in-the-data-model/td-p/780229&nbsp;Looking for something like this:&nbsp;Table NameColumn NameTable1Column1Table1Column2Table1Column3&nbsp;

vijayp · Accepted Answer

Anonymous&nbsp;
In each Table you need to&nbsp;
1. Demote the Header as First Row
2. Transpose
3. do this all tables
4. append all tables and remove unnecessary columns
you will get the result. Hope this helps you
&nbsp;

Forum Discussion

How to extract column names from a table

2 Replies

Related content

Extract initials from names column

Trying to Extract Town name

Extracting complicated text from a column

Trying to extract Town name

Dynamic Column Name

Table Name	Column Name
Table1	Column1
Table1	Column2
Table1	Column3