Forum Discussion
Incorrect values pulled from SharePoint List to Power BI Desktop
Hi,
When I pull data from a SharePoint list into Power BI, the values are pulled incorrectly for columns having the data type -
- Person or Group - instead of names, numerical values are pulled. I guess these are the IDs of the list records
- Lookup - instead of the actual values, '[list]' is pulled in a nested column. When I expand the column, numerical values are shown. Again, they seems like IDs
All other data types are pulled properly.
To work around this problem, I first pull the data from the list to Excel and then to PBI. However, I want to eliminate this manual step as the list will have frequent updates and I will need to pull the list data into Power BI regularly.
What should be done to pull the actual values as they appear in the list?
Hi Enigma ,
1. What you need to know is that the "people" and "group" type columns in the SharePoint list are search columns. You can refer to this post .
2. Based on your description, I think SharePoint references the information in the person selector field and hides the data in the user list. You can refer to this post .
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quick
2 Replies
Hi Enigma ,
1. What you need to know is that the "people" and "group" type columns in the SharePoint list are search columns. You can refer to this post .
2. Based on your description, I think SharePoint references the information in the person selector field and hides the data in the user list. You can refer to this post .
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quick
Many thanks V-lianl-msft
Those links were very helpful.
I used the FieldValuesAsText option to get the values in the table. I only needed the text values and that solved the purpose!
