Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

Column with 365 User Name from Share Point

Good morning, we have a SharePoint list from which we pull the data in Power BI to display the contents of that list.

Everything works perfectly but there is a USER field that is a Person or Group field in the SP list and that collects the data of the user who created the record.

If we try to list, Power BI puts the contents of the USER column with the value "List" and we need it to show us the full name of the user, as it appears in the SP list.

We understand that you are returning a user record with the user's name, email, department, etc... But we only need the name.

We have tried transforming the data in the column using the following formula:

= try [USUARIO][title] otherwise null

But it always gives us the null value.

Can anyone lend us a hand? What we need, as I say, is for the USER column in PBI to show only the user's name (title) of the record it gets from SP

Thanks in advance

1 Reply

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional

    Just expand the field in Power Query with the button in the column header. It varies a little depending on if you're using the 1.0 or 2.0 connector as far as how it expands, but the concept is similar. I did a tutorial that includes this here if it's useful: https://youtu.be/LYu3wqb2Nx4