SharePoint Person or Group field entries returns multiple rows in PBI query and data table
Posted: Sat Oct 19, 2019 1:13 am
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 amount of hours should be ~113k but due to the added rows, it is incorrectly reporting 141k hours.