Error de OLE DB u ODBC: [Expression.Error]

[Syndicate_Admin]

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

[v-janeyg-msft · Accepted solution]

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.

[Syndicate_Admin]

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

[negi007]

@Syndicate_Admin 

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://powerusers.microsoft.com/t5/Building-Power-Apps/OLE-DB-or-ODBC-error-Expression-Error-The-co...

https://community.powerbi.com/t5/Desktop/Data-refresh-error-OLE-DB-or-ODBC-error-Exception-from-HRES...

https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-Expression-error/m-p/442565#M204449

[Syndicate_Admin]

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