Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper II
Helper II

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!


Super User
Super User

@Ericwhv , Try datetime or time.

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

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



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors