How to display an assigned user in a sharepoint list in Power BI (o365)?

[Hemulen]

We have a salespipe list in SP o365 which i want to make an report from.

There's users assigned to leads etc in this list.

As sharepoint o365 doesnt have a userlist available (only for SP admins i think) to make a relationship with (ie a username or an email address) in Power BI this is a problem.

How can i retrieve a list with users from sharepoint to match with the record id in Power Bi?

When i choose name or id it only shows the "record" or "id" not the real name of the user.

[tanveer4m]

Thanks @Vicky_Song Finally i manage to display user name instead of ID

[Anonymous]

Hi 

I used the Get Data / OData feed to import the list but it results in the following error:

Unable to Connect

We encountered an error while trying to connect. 

Details: "Micrsofot.Mashup.Engine1.Library.Resources.HttpResource: Request failed:

OData Version: 3 and 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)

OData Version: 4, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)

OData Version: 3, Error: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)"

Regards 

[Anonymous]

Hi Vicky,

Please could you explain me in more details to import users data in order to display users name instead of ID.

Thanks in advance

[DolEgon22]

This is not a solution as the end result is exactly the same. If I select any of the fields after setting up the relationship, it still shows numeric values instead of the user's name. 

[Anonymous]

And then what? I imported the user info list successfully and joined it to the other list. But...I still am only getting IDs and using the "title" dimension of the user info list doesn't give the right behavior either.

[MasterShake]

I am so sick and tired of partial, crypic answers!!!!!!!! 

[MasterShake]

I am so sick and tired of partial, cryptic answers!!!!!!!

[Robin7387]

Yes!!!  You are sooo right.  Crptic answers with not very good solutions!  I was able to successfully import the User Information List.  However, when it was done, there does not seem to be any relationships.  I tried auto-detect... nothing.  I tried manually...  nothing.  I am at a loss as to why we would look for a User ID to compare.....

[MarcNavarro]

Hello,

When I connect to your URL Power BI show me this error: Details:

"Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.)"

But if I navigate using IE to the URL it show me the XML format data. Any idea?

Thanks.

[jaypatel1447]

Maybe You are trying to import data from Sharepoint list

https://xxxx.sharepoint.com/teams/JayPatel(ORv2.01)/Lists/ ** I was getting same error while importing data from this link

https://xxxx.sharepoint.com/teams/JayPatel(ORv2.01)/ ** Try this one. Remove the List from link. 

Let me know if this not work!!

[hollyketchel]

I also get the error

OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.)
OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.)
OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Resource not found for the segment '_api'.)"

Any resolution?

[monkey]

Hi hollyketchel

How did you overcome the 404 error?

My PowerBI report was working fine until about a week ago and now it cannot see the user information list on my sharepoint site.

Thanks

[jdoshi65]

Provide SharePoint site URL instead providing List URL

[hollyketchel]

Late perhaps but I found this post very helpful:

http://christine-payton.com/accessing-sharepoint-user-profile-data-with-power-bi/

[duncfair]

this site seems to have been taken down.

[Hemulen]

Thanks. But if there's new users i need to regularly import a new list with users.

I solved it by creating a workflow updating a new field with the name of the user. Retreiving the info from the assigned user. In this way i don't have to update a list with users.

Thanks anyway.