column shifted when import data to PowerBI

Hi pang22 ,

This column offset problem can usually be caused by several reasons:
CSV file format issues: CSV files with inconsistent delimiters or containing extra commas or other symbols can cause columns to be misaligned on import.Power Query provides a number of setup options that can help resolve this issue
Changing the default Apply all line breaks to Ignore quoted line breaks will ensure that Power Query ignores line breaks within double quotes and treats them as part of the same line without causing the data to be misplaced.

Special characters or line breaks in data: If some data fields contain special characters such as line breaks, commas, or quotes that are not properly escaped, Power BI may parse the data incorrectly when importing.
You can check the CSV file if its delimiters are correct, especially if there are extra commas or tabs.
I've also found some documentation on this that has been resolved for you I hope this helps!

Solved: Power Query - csv file column values is mixed with... - Microsoft Fabric Community
Solved: Re: Issue with some rows in CSV import - Microsoft Fabric Community

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.