Forum Discussion

rmba22875's avatar
rmba22875
Frequent Visitor
3 years ago
Solved

Issue with some rows in CSV import

I am importing a large CSV file which I import into PowerBi. Whilst checking all of the data though i have discovered that a handful or rows are importing under the wrong column headers. My first c...
Need Help
  • halfglassdarkly's avatar
    halfglassdarkly
    3 years ago

    Try checking the settings for your data source (cog icon to right of Source in your Applied Steps pane).

     

    There is a CSV import setting called Line Breaks. Try setting this drop-down to 'Ignore quoted line breaks' and see if it resolves your issue.

     

    I've run into this issue where CSV files contain line breaks, usually within text fields. Setting it to ignore quoted line breaks will force Power Query to only delimit by comma or your specified delimiter.

halfglassdarkly's avatar
halfglassdarkly
Responsive Resident
3 years ago

Try checking the settings for your data source (cog icon to right of Source in your Applied Steps pane).

 

There is a CSV import setting called Line Breaks. Try setting this drop-down to 'Ignore quoted line breaks' and see if it resolves your issue.

 

I've run into this issue where CSV files contain line breaks, usually within text fields. Setting it to ignore quoted line breaks will force Power Query to only delimit by comma or your specified delimiter.

  • rmba22875's avatar
    rmba22875
    Frequent Visitor
    3 years ago

    Amazing! Thank you that worked a treat