Forum Discussion
Power Query unable to retrieve table from a SharePoint person column
Hi allan_t
As you said "When I've used this method in Excel Power Query, I'm able to expand the column, but in Power BI Power Query it's not working. " Do you mean at the same time, it does not work in Power BI's Power Query, but it works in Excel's Power Query? Or it used to work in Excel's Power Query in the past but haven't tested it in Excel now?
Best Regards,
Jing
Thanks for helping on this. I just tested in Excel Power Query and am getting the same error message. In this Power Query Editor screenshot from Excel, the SharePoint list Submitter column displays as a Record and can be expanded, no issue. The LeadAssigned column displays as a table and can not be expanded. The LeadAssigned column is the one I'm having an issue with. The Submitter column is a single person column type. The LeadAssigned column is a multiple person column type. Is there a way for me to retrieve the people list in Power Query for the data stored in the Lead Assigned column?
Here's the error I get with the LeadAssigned column when I try to click the table hyperlink in a row.
When I click the Expand column icon for LeadAssigned, Power Query hangs for a few minutes, then gives this result: