Forum Discussion

PaulBoyes's avatar
PaulBoyes
Regular Visitor
10 years ago

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

  • Beckham's avatar
    Beckham
    Icon for Advocate II rankAdvocate II
    10 years ago

    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. 

     

     

     

    • johnmark's avatar
      johnmark
      New Member
      8 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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