Forum Discussion

aspitalnick's avatar
aspitalnick
Frequent Visitor
3 years ago
Solved

Help getting data out of a sharepoint list

I am accessing a Sharepoint list with PowerBi and the fields that have dropdown lists show up as [list]. If tried multiple methods to extra the single result in PowerBi but to no vail. The field is c...
  • KNP's avatar
    3 years ago

    Ok, so if you delete the step that was created when you clicked on the word in the list, do you see this icon in the column header for that column?

     

    If you do, click on that and choose either 'Expand to New Rows' or 'Extract Values...'