Dataverse Direct Query Date Slicer Filter Issue

When I add a date slicer to the report (marked as a Date Table) almost all of the data disappears from the column chart, even when all dates are selected with a slider control. There are approximately 1,800 records it should be capturing, but this is reduced to 36 records after adding the slicer.

This is the relationship between the tables:

I've used the Performance Analyser to try to find out what's happening when I add the slicer, and it produced the following output:

I cannot work out why the vast majority of records fail to be captured, the date slicer captures the full range of dates. Both the slicer date and the date in the table the chart is modelling are of 'Date' type (not 'Date/Time').

Is there anything I need to be aware of when using Direct Query for Dataverse tables that might be causing the problem?

Any advice would be gratefully appreciated.