cancel
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.

Reply
Ericwhv
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

Ericwhv_1-1678968762476.png

 

 

in the Power BI what it is showing (text)

Ericwhv_0-1678968720873.png

 

once change it to Date, it got an error

Ericwhv_2-1678968794609.png

 

Thank you everyone!

 

2 REPLIES 2
amitchandak
Super User
Super User

@Ericwhv , Try datetime or time.

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

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

Ericwhv_0-1678978212717.png

 

Helpful resources

Announcements
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