Forum Discussion

CROKat's avatar
CROKat
New Member
2 years ago

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 com...
Need Help
christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

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: https://youtu.be/LYu3wqb2Nx4?si=xxo34YYWcZ57htVM