Forum Discussion
Helper IIIcolumn 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 CommunityHope it helps!
Best regards,
Community Support Team_ Tom ShenIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
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.
Helper IIIAnonymous
Thank you. Where can find the line break buton?
Hi pang22 ,
If you want to use the web to fetch data, then we need a web link to store the CSV file, then Power BI will automatically detect the file format and provide appropriate options, such as “Ignore quoted line breaks” and other data handling options.
I hope this can only help you!