Incorrect values pulled from SharePoint List to Power BI Desktop

[Enigma]

Hi,

When I pull data from a SharePoint list into Power BI, the values are pulled incorrectly for columns having the data type -

1. Person or Group - instead of names, numerical values are pulled. I guess these are the IDs of the list records
2. 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?

[V-lianl-msft · Accepted solution]

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

[Enigma]

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!