Forum Discussion
nogi
8 years agoAdvocate II
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 do i get it to appear the same in Power BI as when it shows, it comes up like: ...
v-yulgu-msft
8 years agoMicrosoft Employee
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