Hello, I have downloaded a csv file and import to PowerBI. But why the column shifted and not show the Contract No?

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 issueChanging 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 CommunitySolved: 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.

column shifted when import data to PowerBI | Microsoft Fabric Community

Forum Discussion

Related content

Time Shifted Measures

Shift a column down by one line

Day shift and night shift

POWERBI Subscription

Duplicate, shift, then aggregate