Forum Discussion
Jbro
4 years agoFrequent Visitor
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...
- 4 years ago
I figured it out! https://community.powerbi.com/t5/Power-Query/Error-when-expanding-a-column-No-columns-were-found/td-p/2310889
AllisonKennedy
Community Champion
4 years agoJbro 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.