Forum Discussion
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 check was to make sure my source data was all correct, which it is.
For example all of these columns under currency code in the file have currency codes and yet in powerbi they are in different columns.
Hopefully someone can help!
Thanks
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.
3 Replies
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.
Amazing! Thank you that worked a treat
Excellent!