XLSB file date getting error

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!