Power BI data model not showing all Dataverse table rows

(0) Share

Report

Posted on by EjazK

287

Hi guys,

I'm experiencing a strange issue using Virtual entities with Power BI. In the screenshot below you can see the worker entity on the right in Dataverse (109 rows up to 0141 personnel number) and on the left in Power BI data model (82 rows up to personnel number 0106). For some reason not all the rows in Dataverse table are visible in the data model table in Power BI. However, if I check the rows in the PowerQuery editor, I can see the same number of rows as in Dataverse (109 rows up to personnel number 0141). I've removed all the fields where there was some automatic summarization applied but still not all the rows are showing in the model so there must be some filtering going on elsewhere?

Has anybody come across this issue before? I'm going crazy trying to resolve this!