Sharepoint list colum issue

[Obeybe]

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

From Excel

Regards

Obeybe

[lbendlin · Accepted solution]

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