KPI order date(Power BI API) is referring the wrong date column in Business Central.

Ricardo_02 — Sat, 16 Sep 2023 20:10:23 GMT

Hello Community,

I am currently in the process of displaying the KPI incoming orders with the help of PowerBI.
For this purpose, our incoming orders (sales orders) of the current month are to be filtered according to the orderdate.

But now I have the following problem. In BusinessCentral, the order date is always the order date. See screenshot

When I use PowerBI to pull the orderdate column from the salesorders table, the date entries are different from those in Business Central.

The entries from the orderdate column(in Power BI) correspond 1:1 to the posting date from BusinessCentral.

The conclusion I draw from this is that either PowerBI pulls the postingdate twice. Once correctly and once incorrectly under the orderdate column.

Does somebody have another explanation or an idea how I can work around this problem?

topic KPI order date(Power BI API) is referring the wrong date column in Business Central. in DAX Commands and Tips

KPI order date(Power BI API) is referring the wrong date column in Business Central.