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
Most 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 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

    • christinepayton's avatar
      christinepayton
      Most Valuable Professional
      2 years ago

      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.