[DataFormat.Error] Format error in package.

[Anonymous]

Hi Everyone,

I'm getting data from a SharePoint folder from xlsx tables, everything works fine till I Apply changes, it gives me this error

"OLE DB or ODBC error: [DataFormat.Error] Format error in package.. An unexpected exception occurred."

I checked every step in the power query and noticed that this error occurs when loading more data while filtering a column and this error starts from expanding step 
Also, I checked the regional format for these xlsx files and they are the same

Anyone can help!!!

[v-eqin-msft · Accepted solution]

Hi @Anonymous ,

You may use try...otherwise to handle such an error, like:

= Table.TransformColumns(Source, {{"column name",each try DateTime.FromText(_) otherwise null, type datetime}})

A similar thread:

https://community.powerbi.com/t5/EdX-Specific-Training-Discussion/OLE-DB-or-ODBC-Error-DataFormat-Error/td-p/125137

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks a lot Eyelyn, it works