Refresh failure

Hello,pborah and FarhanJeelani ,thanks for your concern about this issue.

Your answers are excellent!
And I would like to share some additional solutions below.

Hi,Kalina .I am glad to help you.

1. Please check whether the data type format of the data in your data source is correct.

2 If you could ensure that there is no problem with the data itself, please try to clear the data source cache in power BI Desktop.

3. Check whether your Power BI Desktop version is a newer version, if the version is too old, you can update the Power BI Desktop version!

Hope the following related articles and issues can help you.

How to solve OLE DB or ODBC errors in PowerBI - CloudFronts

When using Power BI Desktop, you may encounter various data loading failures, but some of them can be resolved after clearing the data cache and reopening Power BI Desktop to reload the data.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.