Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
When I pull data from a SharePoint list into Power BI, the values are pulled incorrectly for columns having the data type -
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?
Solved! Go to 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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |