Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
My data table has more than 100 columns. I would like to just copy column headers and paste into excel and verify column names with another table.
How do I just copy column headers only? I have been using 'copy table' and just keeping column headers only for verification.
Thanks
Solved! Go to Solution.
Hi @anantv ,
In Power Query, just create a new blank query and paste this over the default code in Advanced Editor:
let
Source = Table.ColumnNames(queryName)
in
Source
...where 'queryName' is the name of the query that you want the list of column names for.
Pete
Proud to be a Datanaut!
Hi @anantv ,
In Power Query, just create a new blank query and paste this over the default code in Advanced Editor:
let
Source = Table.ColumnNames(queryName)
in
Source
...where 'queryName' is the name of the query that you want the list of column names for.
Pete
Proud to be a Datanaut!
Pete,
Thank you very much. This is exactly the solution, that I needed.
Thanks
Hi, @anantv
Assuming you are using Power BI.
1. Just export the table to csv. open the file, the first row should contain column names, just select the first row or the row that contains column names then copy paste it.
or
this will only have column names.
Proud to be a Super User!
Hi Rubayatyasmin,
Thank you for the response.
I had been extracting column names as option 1.
I was not able to use the second option (seems very interesting) as Structured column menu grouping is not available in my organization's O365 Power BI.
I appreciate your help. Thanks.