Get data from Excel

[welaish]

When I get data from an excel sheet it always gets column names as Column1, Column2, column3.....etc.

and

The columns names comes withint the data set. Jan, Feb, Mar......etc.

I want the column names to be the Jan, Feb, Mar....etc. how it can be done?

[ankitpatira · Accepted solution]

@welaish I believe you're trying to import using powerbi desktop? There is seperate forum for desktop and this is for powerbi service.

In powerbi desktop go to Query Editor and under Transform tb you can select 'Use First Row As Headers' which will promote your first row as headers.