Data not showing properly when loading SharePoint online list to Power BI .

[Anonymous]

Hi, I am trying to load sharepoint online list to Power bi which is successfully done.

But when i go to transform queries and look the values in columns its replicated as [Records] or Table instead actuall value. 

When i double click the [Record] is shows as Label,TermGuid,Wssid. Could anyone please advice how to get the actual value.

Thanks in advance.

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @Anonymous ,

Try to click expand.

refer:

https://support.microsoft.com/en-us/office/work-with-a-list-record-or-table-structured-column-power-query-d5e552be-c143-4f06-9a5e-0960bbaaf480 

Best Regards,

Lucien