cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Sharepoint list colum issue

Hi everybody,

I'm new in Power Bi and I try to create a report from an Sharepoint online list.

When I export the list in excel and open it in PowerBi  I have a column named "Meeting members"with aal the names of the persons who will be present.

When I open the list directly from Sharepoint this "Meeting members column is not visible.

I see two other column named "Meeting membersId" and "Meeting membersStringId".

Can I rebuild the "Meeting members" column with all the names.

From PowerBi

Obeybe_0-1602665472808.png

From Excel

Obeybe_1-1602665562239.png

Regards

Obeybe

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

Import the "User Information List"  table from the same sharepoint

Split your memberlist column by delimiter, split into rows.

Join the tables based on the ID

View solution in original post

1 REPLY 1
Highlighted
Super User II
Super User II

Import the "User Information List"  table from the same sharepoint

Split your memberlist column by delimiter, split into rows.

Join the tables based on the ID

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors