Hi all,
My organisation recently started using D365 for Finance. To analyse the data we use the Common Data Service/Dataverse and Power BI.
I am now looking into each employee's leave balance which is stored in the table AGR_WorkerHolidayBalanceEntity. In the Power Query i see multiple rows per person that add up to the total leave balance correctly.
However, in the data visualisation i only get 'some' rows instead of all. To see if this is because Power BI aggregates data or 'helps' in some other way we have tried mulitple options (clearing cache, refresh data, only load this single table into Power BI, change data types, add an (extra) index column, remove null values) but nothing helped so far. Somewhere between the Power Query and the data visualisation we lose rows.
Has anyone else experienced this or does anyone know a possible solution?
Cheers,
Richard
