Filtering by date causes error - Business central connector

[james86]

I have created a brand new, very simple data model with a single table "Sales Invoices". This table is sourced from the business central connector.

*I experienced this issue in a much larger model, but have created a new one to ensure the issue is not caused by anything else in the model.

If I then create a table visual and place the quantity field, it will give me a summary of the quantity for the whole table. Everything looks good. 

If I add a filter (to any level, visual/page/report) on the posting date, very strange things start happening.

With basic filtering, I can select any number of dates that exist in the table, and the table visual will correctly sum the quantity for those dates and display it.

If I change the filter to advanced, and "is" some date that I know data exists (3 feb 2025) I get

but, if I add "is on or before" any date in the future (thereby not filtering anything) and include the same criteria as above as an "and" in the filter, it works.

I have been trying to figure it out for hours and am having no luck. I have already

 - Created a new data model and replicated the issue

 - uninstalled and reinstalled powerbi desktop

 - adjusted the query to explicitly set the posting date field to date (it was already coming across as a date field)

 - checked all locale settings

I am running PowerBI on a Parallels VM, but I have never had a problem with this for years.

[peef1987]

Thank you for posting this - I thought I was going mad!