Forum Discussion
Solved
Power Query Shuffles Data When Importing CSV
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 valu...
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.
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.
Thank you 😊
You were spot on. That fixed my issue.