Strange Power Query/Model behaviour with D365 Power Platform Virtual tables

[Ejaz]

Hi guys, 

I'm experiencing a strange issue using D365 Virtual entities on Power Platform 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. 

I don't understand why the model is not showing all the rows visible in PowerQuery and/or Dataverse.

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

[jbwtp]

Hi @Ejaz,

Not sure what the rest of your data looks like (and what data do you use in the visual).

If PQ sees the data, it should be available in the Designer/DAX.

I guess, one option why you can't see it could be a result of "pivot-table" type of behaviour: when the rows with no numerical data is not showing. E.g. If you pivot this table by id:

id	value
1
2
2	3

Only id = 2 will show up in the resulting pivot table. Maybe you are observing the same behaviour?

OI wonder what number of rows you may get with this measure (just use your table name):

Measure = COUNTROWS(Query1)

Cheers,

John