Date differences when loading local csv file and sharepoint csv file

[TechR21]

Hi,

When I load files from my local directory into powerbi i have the following correct dates (the date - month is a an added column in powerbi) :

When I put those same files in a sharepoint folder and load them into powerbi I see the following:

For some reason he makes January from those dates.

I already try to changed the format with: 

= Table.TransformColumnTypes(#"Custom1", {{"date", type date}}, "en-US")

But this doesnt seem to work. How can I get the correct dates/months?

[vicky_]

It might just be that Power Query is loading different sections of the csv but it's the same data underneath. Have you tried sorting the column by date, or even loading into PowerBI to compare the differences?