Forum Discussion

MatthewBI's avatar
MatthewBI
Regular Visitor
1 year ago
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...
Need Help
  • Shahid12523's avatar
    Shahid12523
    1 year ago

    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.

Shahid12523's avatar
Shahid12523
Icon for Community Champion rankCommunity Champion
1 year ago

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.