Date failure

[MMC16]

Hi all, 

I have an unsual error which I am wracking my brain to try to fix, but cannot. 

As most spurious issues, I haven't made any changes and it just started happening randomly today. 

Data is storred in Sharepoint excel file in format as seen below. column B with dates in and is formatted as a date 

When the connection to PBI is made, you can see the dates are not being pulled thorugh correctly. 

Any ideas on solution or error fault? 

[edhans · Accepted solution]

Convert to date using the Locale option.

Your formula would look like then when you press OK.

= Table.TransformColumnTypes(Source, {{"Date", type date}}, "en-BM")

Pick the correct locale for your data source, but Bermuda/English will work for dates in those formats.