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.
Go to 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
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021