Power BI Report How to Use SharePoint Person Field

This video will walk the process of how to use SharePoint List Person Field in Power BI Reports.
First, I will connect a SharePoint list with Power BI, then I will show you how to retrieve the person’s name from the person column. When you connect SharePoint list with Power BI, by default you can only see the id’s for any person field. To get the person’s name and other information, you will need to connect Power BI report to the user information list and do a lookup to retrieve person name.

★ TABLE OF CONTENTS ★
• 00:00 Intro
• 00:42 Connect Microsoft List to Power BI Desktop
• 03:40 Set up User Information List relationship in Power BI
• 05:10 Set up Column using LOOKUPVALUE Function to Retrieve Person Name
• 05:58 Outro & Subscribe

🔴 *** BE OUR FRIEND ***

🔎 HASHTAGS 🔎
#PowerAutomate
#MicrosoftLists
#LookupValue

[ronelsindo]

Thank you so much. I've been struggling with this. It all worked out fine when I was using the online version of Power BI, but then I got stuck on the desktop version. I can finally get a full night's rest tonight!

[alexbrixton]

Over a year since you posted this and still VERY HELPFUL!
Thank you so much!

[itahir]

Thank you so much. Finally I figured that out by watching your very simple and complete instructional tutorial!!

[paromitamondal]

Excellent! You saved a lot of time, Thank you so much !!!

[JoshiJourneyLife]

Thanks, it works well if my person field is single value. what if there are many people in that field, like 2-3 authors per book? any simple workaround like this one? I dont want to go about expanding tables in power query, it sometime behaves weird say I have multiple people field, say editor (single person), authors (many people), resellers (many people)

[akkaradechsrithongchai]

I got it !! the hidden List . Thank you

[abbasthegreat]

How to get values for a multi select person or group column? It generates a list column in Power BI. How to deal with that?

[KelvinR]

I came across an issue where the user does not upload an item the flow wont run successfully. How can i create an action where the users does not add an attachment it skips from the grab attachment action.

[shashigaikwad]

You've earned a sub. Thanks for your help.

[littlesunshine]

Hello.
I have a two column- comments and created by that contains text values
I want to filter only those comments who entered by some specific user that belong to AD group. (This group has SharePoint access permission as members) I am checking by their name manually but I want some solution to filter the name only if user name is belong to that group.
So that if new user come
it should check automatically.

Please reply if you can suggest or anyone in this chat.
My datasource is SharePoint.

[ramonseila]

in my list the column type person is enabled for multiple people, as it would be in this case

[fanzfanzilla]

Thank you for the video. Its very helpful. If I have multiple ID's in the person column that I want to show in the project data table in the same field, how do I do this? Is it possible?

[kyleortman]

Thought I did everything right but it put my name in a bunch for other people. Not sure why.

[assyabassya]

Thank you very much for this video - great tip for single name in the Author column.
And do you have a tip how to show all names if the SharePoint column type is also Person or Group but multi-select? For example, if I have several Authors?

[robertjohnson]

Did not see a User Information List or UserIno. :(

[abc]

What do i do if there is only the word [List] instead of the id number?

[astridgap]

Hi, what if my power BI has only [list], I´m having troubles with changing it

[mohamedalmansoor]

This is driving me nuts
I'm getting different IDs from the SharePoint list compared to the user information list
Not IDs of the same persons

[oddreonuhh]

My SharePoint List doesn't have an author ID or editorID column. any ideas why I don't have those?