Forum Discussion
Incorrect values pulled from SharePoint List to Power BI Desktop
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
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!