If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

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

Thread starter venetianjigsaw
Start date Oct 18, 2019
Tags

data entries fields sharepoint total

venetianjigsaw

New Member

Oct 18, 2019

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?