Power Query Shuffles Data When Importing CSV

[khardu]

Hi Power BI Team,

I am having trouble when importing data from CSV in Power BI. What happens is when Power Query brings the data it populates the data from one column into another, like some values from text fields into numbers, and some from percentage field to text field. When I view the data inside the CSV, it's correct, and everything is in its own column but as soon as I import via Power Query it's all messed up. I have been importing CSVs for a long time but this is the first time happening.

If it helps, I have downloaded these CSVs from salesforce.

Any idea why it's happening and how can I fix it?

Thanks.

Mudasser

[bcdobbs · Accepted solution]

Hi,

Have a look at 

https://docs.microsoft.com/en-us/power-query/connectors/textcsv#textcsv-delimiters

(Scroll down to "edit source" section.)

Once you set up the import if you click onto the cog next to the source step it should give you an option to ignore quoted line breaks which I think might be causing your issue.

[khardu]

Thank you 😊 

You were spot on. That fixed my issue.