Forum Discussion
Error de OLE DB u ODBC: [Expression.Error]
Hi, Syndicate_Admin
If you delete 2019 data then there is no problem. I think you need to check 2019 data.
You can refer the steps: Configure incremental refresh for Power BI datasets - Power BI | Microsoft Docs
If it doesn't solve the problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It looks like to be a data conversion error. Please check if your date column has any non-date values which causing this error to appear. You could remove auto conversion from value to date in the powerquery and try to do in the powerbi desktop.
below are some links which can guide you in the right direction.
https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Expression-error/m-p/442565#M204449
Hello @Syndicate_Admin ,
the date column was of the date/time data type, as indicated so that you can apply the parameters in incremental update. I hadn't had any problems until I added 2019 data to the source file and updated it, to see if I was doing the incremental update.
Thank you
