Forum Discussion

nogi's avatar
nogi
Advocate II
8 years ago

SharePoint Lists - Merge rather than split into rows

I have a SharePoint online list that i import which has users that come in from another SharePoint list:

 

How it appears in sharepoint

How do i get it to appear the same in Power BI as when it shows, it comes up like:

in power bi

And if i link in the table it pulls the username from, it duplicates each task per user rather than show the task once and combine the list of users into the field as it does on sharepoint.

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi nogi,

     

    After fetching data from SharePoint online list, multiple value field values are returned as a list. You can click the expand icon beside field name to get detailed records. With list items, the expand icon will duplicate the entire record for each value on the list.

     

    For more information, please refer to: A Simplified Method of Working with SharePoint Data in Power BI

     

    Best regards,
    Yuliana Gu