SharePoint Online List not displaying data - Says [List]

[Anonymous]

Hello,

I am connecting to a SharePoint Online List. When I go to the Power Query it shows as [List]. I attempted to expand the data and it changed fro [List] to [Record]. I spent hours on yesterday searching the board for assistance, but nothing is working. 

The  particular column(s) in the SharePoint list are "People or Group". Not sure if that helps to identify a solution, but please anybody HELP! 

[lbendlin · Accepted solution]

Add the "User Information List"  to your data sources, link it in the data model based on the ID.  That method is far more efficient than trying to use the expand function.

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Please refer this topic.

https://community.powerbi.com/t5/Desktop/How-to-display-an-assigned-user-in-a-sharepoint-list-in-Power-BI/td-p/32146 

And this blog.

https://whitepages.tygraph.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/ 

Best Regards,

Jay

[v-jayw-msft · Accepted solution]

Hi @Anonymous ,

Please refer this topic.

https://community.powerbi.com/t5/Desktop/How-to-display-an-assigned-user-in-a-sharepoint-list-in-Power-BI/td-p/32146 

And this blog.

https://whitepages.tygraph.com/2018/01/using-power-bi-to-report-on-person-fields-in-sharepoint/ 

Best Regards,

Jay

[lbendlin · Accepted solution]

Add the "User Information List"  to your data sources, link it in the data model based on the ID.  That method is far more efficient than trying to use the expand function.

[Anonymous · Accepted solution]

Thank you! This fixed my problem.