Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
User | Count |
---|---|
91 | |
73 | |
68 | |
63 | |
55 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |