cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaulBoyes
Regular Visitor

csv data - not recognising first line as file names.

I am using a number of CSV files as a data source.  Mostly this is fine but there are a couple of files where Power BI does not recognise that the first line contains the field names.  

 

So when I look at the column names for those files they are displayed as Column1, Column 2 etc instead of the field names.

 

If I use Excel or Notepad to open the files it is absolutely fine.  I simply cannot detect any problem with these files.

3 REPLIES 3
Beckham
Helper II
Helper II

This happens to me all the time. When you import it using powerquery, click on the button that says "Use First Row As Headers". Should fix it. 

 

 

 

1.PNG

My home tab does not show the "set first row as headers" option

v-yuezhe-msft
Microsoft
Microsoft

Hi @PaulBoyes,

Could you please share sample data of the problem CSV file? And we need to know what is the connection string in your Advanced editor.

Based on my test, Power BI will add "Promoted Headers" in Advanced editor when you import CSV file which contains field names, below is an example for your reference.

let
    Source = Csv.Document(File.Contents("C: \Sparkline-excel.csv"),[Delimiter=",", Columns=2, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Category ", type text}, {"value", Int64.Type}})
in
    #"Changed Type"


And in your scenario, you can use the first row as headers to work around this issue.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors