Read CSV files under a Sharepoint folder with Power BI

[Anonymous]

Hi,

I got a trouble when I load CSV files under a Sharepoint folder by using power query. Data looks normal when I view the files online. However, if I load files into power query, data cannot be parsed correctly, a few rows and columns are mismatched, even row number has increased . Same problem occurs when I load the data with Excel. But I found it works great when I use python pandas to read. That really makes me confused.

Thanks in advance!

[Anonymous · Accepted solution]

[Updated] I found the Problem that the Line breaks option should be set as "Ignore quoted line breaks", because there is a long text column in my data which might contains line breaks sign