SharePoint Person or Group field entries returns multiple rows in PBI query and data table

venetianjigsaw

New Member
Joined
Oct 18, 2019
Messages
1
I have a direct connect to a SharePoint List. The problem that I am having is that in my report the data appears to be skewed due to me using two SharePoint Person or Group fields. What I have been able to determine is that if there are multiple entries in the two fields, then there are rows added in the query and data tables to accommodate for the additional names that were entered in those fields. The total amount of entries should be 329, based on the ID numbers but the query and data tables reflects 354. There were a couple of deletions so the number of total entries will be a couple less, but I think that you get the idea. Also, the total amout of hours should be ~113k but due to the added rows, it is incorrectly reporting 141k hours.

Any ideas?
 

Forum statistics

Threads
1,077,642
Messages
5,335,416
Members
399,014
Latest member
emalabel

Some videos you may like

This Week's Hot Topics

Top