Forum Discussion
Solved
SharePoint List Data
Hello, I am a new PBI user. I imported a SharePoint list as a data source to PBI desktop. When I loaded the data I transformed it. All fields are populating as expexted except one gives me an ID...
Jbro Screenshots might help. I'm guessing this is either a 'person' type column in sharepoint or maybe a lookup column. You should see a column with the same name (such as "Employee") as the column in SharePoint, but in PowerBI it will have 'record' all the way down and the column heading will have a double arrow next to it. Click the double arrow to expand that column and choose the 'Name' column or whatever info you want.
AllisonKennedythank you for replying!
I have screenshots and more info:
when I select the double arrows it only allows me to extract values.
And there are two columns representing this field
This is what the field/search looks like in SharePoint (there can be one or more employees in this category: