Uploading from Sharepoint Online List - data display

[Morti266]

I have uploaded data from a Sharepoint Online List - everything is fine EXCEPT where the data in the Sharepoint list is selected from either a drop down list or from the businesses Active Directory of users.  Here is just displays [List].  How do I get the real data to be displayed

[v-yiruan-msft · Accepted solution]

Hi @Morti266 ,

You can refer the following links to get it:

Power Query SharePoint Online list connector - Power Query | Microsoft Learn

How to expand a list of records in a query | Microsoft Power BI Blog | Microsoft Power BI

Best Regards