Data source error: Not a legal OleAut date.. The exception was raised by the IDataReader interface.

Hi. How are you checking for valid dates. That error means you are using a wrong date, it could be something like 22/22/0100 with wrong month or year. You can check it re ordering by that date, filtering for keeping errors or even using a custom function like: 

= try Value.Is(Date.From([Date]), type date) otherwise false

Do a check for every date column in the semantic model. Reordering usually shows a wrong value when it's too high, too low or totally wrong. But if the issue is "10/22/2025" instead of "22/10/2025", that would be found with keep errors filter after converted to date.

I hope that helps, make sure after you refresh the whole dataset of desktop, you don't have any warning.