Forum Discussion
Error de OLE DB u ODBC: [Expression.Error]
Good afternoon
I'm setting up an incremental update from my Power BI Desktop with my premium license per user.
I filtered the main table by the RangeStart and RangeEnd parameters and added 20 more records to my data source to see if I'm performing the incremental update. Parameters run until 31/12/2018 but the added data are from 2019.
When I select Close and Apply from the Editor I get the following error:
OLE DB or ODBC Error: [Expression.Error] The Date operation failed because the resulting value does not fall into the range of allowed values.
I extended the range in the RangeEnd parameter to get the new records, but it still gives me the same error. Does anyone know how to fix it?
Thank you very much to the community.
Best regards
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.
5 Replies
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
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.
Thank @Syndicate_Admin,
had two filters applied one after the other. I took one of them off and it's settled.
Thank you very much for the help of the community.
Best regards
Hello good afternoon, I have a similar error, first I uploaded some excel files through folder connection I made two metrics, but I deleted the table and the metrics now I am trying to upload the table again but it does not let me, I changed the name of the folder and the files, but still it does not let me, When I go to load the shows me is the name of the previous file and not the current one I thank support, [email protected]
[@Syndicate_Admin] [Could not save modifications to server, error returned, ole db or ODBC error [expression error] key did not match any rows in the table ]
