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.
How can I get the name(s) from a field in SharePoint for Power BI? I see that the problem with this being a Table instead of a record is due to the fact that in SharePoint, this can contain more than one person, understandably. How do I get this data and represent it into a report where I can slice data on these results? Thanks for the information.
Solved! Go to Solution.
Hi @guyatisk ,
In the Power Query editor, locate the column with the Multiple Choice Person field. Click the expand icon (two arrows) on the column header to expand the field. If the name is in a nested table within the expanded column, you will also need to expand those tables.
You can refer to the similar posts that may be helpful to you:
Using Power BI to Report on Person Fields in SharePoint – The White Pages (bifocal.show)
Sharepoint person column with no fields? - Microsoft Fabric Community
How to retrieve "correct" column names from ShareP... - Microsoft Fabric Community
SharePoint Online List column with multiple person... - Microsoft Fabric Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @guyatisk ,
In the Power Query editor, locate the column with the Multiple Choice Person field. Click the expand icon (two arrows) on the column header to expand the field. If the name is in a nested table within the expanded column, you will also need to expand those tables.
You can refer to the similar posts that may be helpful to you:
Using Power BI to Report on Person Fields in SharePoint – The White Pages (bifocal.show)
Sharepoint person column with no fields? - Microsoft Fabric Community
How to retrieve "correct" column names from ShareP... - Microsoft Fabric Community
SharePoint Online List column with multiple person... - Microsoft Fabric Community
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
108 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |