Getting wrong data from Sharepoint List

[cittakaro]

I am trying to get data from Sharepoint list into Power BI Dekstop, but I am getting the wrong information. For example I have sharepoint list "Task" with column "Assigned To" filled with correct value, but all I get in Power BI Dekstop is value '[List]'. 

Thanks 😄

[morgade1 · Accepted solution]

I believe that is because SharePoint references the info in the people picker field with the data in the hidden user list. To connect to the list append this /_catalogs/users/simple.aspx to the end of the site and you should see the list. I would assume that in PowerBI you should connect and do a merge of the two related lists to fill in the proper information. 

[cittakaro]

Thanks Morgade1,

you are right. There is hidden 'Users' list that I can bring in.

Thanks Ross73312,

You are right, I can see the value after I expand the icon. All I need to do now is link that ID with 'Users' list.

Thank you all, really appreciate it.

[Anonymous · Accepted solution]

In your query editor, these columns should have a slightly different icon on the right hand side of the field name (normally a drop arrow).  This should let you grab the values from the 'list' and convert it into data for the row.  Even though there might be only a single value, its really down to how the data is stored.

Fixing in the query editor should give you the value your looking for.

[morgade1 · Accepted solution]

I believe that is because SharePoint references the info in the people picker field with the data in the hidden user list. To connect to the list append this /_catalogs/users/simple.aspx to the end of the site and you should see the list. I would assume that in PowerBI you should connect and do a merge of the two related lists to fill in the proper information. 

[morgade1]

I believe that is because SharePoint references the info in the people picker field with the data in the hidden user list. To connect to the list append this /_catalogs/users/simple.aspx to the end of the site and you should see the list. I would assume that in PowerBI you should connect and do a merge of the two related lists to fill in the proper information.