Forum Discussion
Solved
DeltaLake.Table Data Loading Issue
Description: We are experiencing inconsistent row loading behavior when querying Delta tables through DeltaLake.Table() in Power Query (ADLS Gen2). Context: Our Delta table contains an invoice wi...
The missing row is due to a bug in DeltaLake.Table() filter folding — #date with > causes a precision mismatch.
How to Fixes:
Use #datetime(2021,12,31,0,0,0) instead of #date.
Or use >=.
Or apply the filter inside Power Query (not folded).
Or use the GitHub connector (works correctly).
It’s a connector bug — safe to log with Microsoft.
v-sdhruv
Community Support
Community SupportHi MatthewBI ,
Just wanted to check if you got a chance to review the suggestion provided and were able to resolve the issue?
If you are still facing any problem, let us know.
Thank you Shahid12523 for your input.
The solution seems to be what we suggested ourselves and has worked. However, I am still concerned that > filtering does not apply correctly