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 😄
2 ACCEPTED SOLUTIONS
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.
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.
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.
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.
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.
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.
