Converting Data from SharePoint to PowerBI

[Anonymous]

Greetings everyone, 

I am attempting to use data from my works sharepoint (Acts as a workload planning tool) to create visualizations in Power BI and when the data pulls over, the person that the work is assigned to (We enter their name and it finds them in Active Directory) shows as "List" for all entries.  The majority of the data comes over no problem, its just the Active Directory users (indicating who the work is assigned to, who created it, and additional stakeholders) all shows as "List"

Does anyone have any idea how to get around that?

[lbendlin · Accepted solution]

You can expand list columns into new columns or new rows. The latter is probably your best option.