Power Query Shuffles Data When Importing CSV

Question

Hi Power BI Team,&nbsp;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.&nbsp;If it helps, I have downloaded these CSVs from salesforce.&nbsp;Any idea why it's happening and how can I fix it?&nbsp;Thanks.Mudasser

bcdobbs · Accepted Answer

Hi,Have a look at&nbsp;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.

Forum Discussion

Power Query Shuffles Data When Importing CSV

2 Replies

Related content

Merge statement creates duplicates - Low shuffle merge as cause?

Import Date in Power BI Table

Import correctly CSV into power query

Import Table from Power BI Semantic Model

Import data from power bi