Please help - Filtering by date causes error - Business central connector

[james86]

Hi All,

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

Help would be greatly appreciated at this point!

[james86 · Accepted solution]

For anyone that ends up here, please see answer from user Stinkys here

Filtering by date causes error - Business central ... - Microsoft Fabric Community

The issue is caused by ARM64 architecture/VM usage

[lbendlin]

yep, sounds like a bug. If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .