Solved: Re: Getting wrong data from Sharepoint List

cittakaro · ‎10-08-2017

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 · ‎10-09-2017

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.

View solution in original post

Anonymous · ‎10-09-2017

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.

View solution in original post

cittakaro · ‎10-10-2017

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 · ‎10-09-2017

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 · ‎10-09-2017

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 · ‎10-09-2017

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.