Forum Discussion
Strange Power Query/Model behaviour with D365 Power Platform Virtual tables
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 t...
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