People picker data from SharePoint Online not coming into BI report.

[ncarrier08]

It makes no sense, One people picker comes into BI and you can expand to get the data, another which is configured exactly the same in SPO does not.

How do I get the data out of a list which resolves to a record which resolves to the data???

The list resolves as follows :

[mahoneypat]

You can convert the List of Lists/Records to a table with the button in the ribbon, and then expand it and choose which fields you want to expand.

Regards,

Pat

[ncarrier08]

Afraid not, this does not help it just makes this :

[mahoneypat]

That is still a list.  At this point, hit the "To Table" button to convert this list to a table.  You can then expand the column of Lists, and if needed then expand the table of Records.

Regards,

Pat

[ncarrier08]

That does not work.

I have 1000 rows saying list, If i press on one them and use > "To table" one record goes to table not all 1000.

I need the ability to drill to the list and to the record for all 1000 items and to pull that data back up to the main table.

The biggest confusion to me is I have another people column and this one is working with the expand functionality. 

[v-eqin-msft]

Hi @ncarrier08 ,

https://powerbi.microsoft.com/en-us/blog/how-to-expand-a-list-of-records-in-a-query/

https://radacad.com/convert-flat-list-to-table-in-power-bi-pivot-without-a-set-key-column-using-powe...

https://community.powerbi.com/t5/Desktop/Extract-records-from-a-list-to-table/td-p/208951

https://community.powerbi.com/t5/Desktop/Power-Query-Get-a-Table-from-a-Column-of-Lists-list-of-list...

Hope these help.

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin