Forum Discussion
EricParsons
Oct 31, 2023Copper Contributor
SharePoint and Power BI: Field Not Read in BI - Number Assigned Instead
Hello All, There are probably 1000+ better workarounds, but here’s my situation. I need to connect SharePoint Lists to Power BI (which is pretty easy). However, I have a field on the list called...
luis-ribeiro
Oct 31, 2023Brass Contributor
Hi EricParsons
You need to match those Id's with the data existing in a sharepoint list called "User Information List".
User information list is a "hidden" list in the sharepoint site with the user mapping using that Id value.
Note that each sharepoint site has it's own User Information List and users can have different Id's between sites.
Regards,