Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Solved! Go to 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.
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
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
Proud to be a Super User!
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |