Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
Solved! Go to 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:
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.
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:
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.
Thanks a lot Eyelyn, it works
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.