Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

New Member

Separating data from SharePoint List

I used the Integrate feature to create a Power BI visual using data from a SharePoint List. One column in the list is multiple selection people profiles. When this column is shown in Power BI, it combines the two people in the assigned column, but I'd like to keep them separate. Kind of hard to explain so I am attaching screenshots. 



This is the List. It shows that K.S. is assigned to two projects solo, and one project with H.K. (who is also assigned one solo project). I would like it to show up in Power BI as K.S. is assigned to 3 projects and H.K. is assigned to 2 projects. Instead, it combines them in the report:



Is it possible to separate them out?

Solution Sage
Solution Sage

Honestly I prefer connecting directly to the SP list vs using the "integrate" feature - you get more control of the data. If you use the SP Online List connector, it will let you expand the "people" data fields to new rows, get their name, department, job title, etc - it's much better to work with.


I did a video here on how to connect to SP lists that includes how to get people data into a dimension table so that you can interact with it in the way you're asking: 

Yeah, unless you have thousands of users in your User Information List.  Expanding columns is an expensive action.

Yeah, the new flat architecture seems to help with this some - not having to support a massive number of subsites does wonders for keeping things to a reasonable size. 

Super User
Super User

You would use Power query action to separate the list entries of the users (split column...into rows).

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors