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

Used for anything related to the new Power BI Desktop and Service tools
venetianjigsaw
Posts: 1
Joined: Sat Oct 19, 2019 1:10 am

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

Postby venetianjigsaw » 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.

Any ideas?

Return to “Power BI Desktop/Service”

Who is online

Users browsing this forum: No registered users and 1 guest

cron