Forum Discussion
Anonymous
6 years agoNot applicable
How to keep column names from excel when creating a Blank Table for Data flow?
Hello,
So I am creating a data flow and would like to input data by using "Blank Table" when I copy and paste my data from excel the blank table adds an additional row on top of my top row and names each column with column 1, column 2, column 3... etc. I would like for the blank table to keep my column names as they are without adding the extra row on top with new column names.
Thank you!
1 Reply
- lbendlin
Super User
In Power Query add a transform "Use first row as headers"