XLSB file date getting error

[Ericwhv]

Hi Everyone

me again! 🙂

i have got a project that need to get the file from the sharepoint (because, we update the sharepoint regularly)

and then, the format of file is XLSB

I have a got a problem that the date type, when I try to change it from text to Date format, it got a error, not sure if any way could fix it?

Thank you!

in the Sharepoint Excel, this is what it is showing

in the Power BI what it is showing (text)

once change it to Date, it got an error

Thank you everyone!

[amitchandak]

@Ericwhv , Try datetime or time.

Also, click on the empty space near to error and check and share the error

[Ericwhv]

@amitchandak 
same, still Error, the msg as below
thank you for your help.