Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
105 | |
88 | |
73 | |
66 |
User | Count |
---|---|
124 | |
113 | |
98 | |
81 | |
72 |