Drop down list showing as "list" in Power Bi report

[Elliottd]

Hi Community,

I have a Power Bi report pointing to a Sharepoint online list. In the Sharepoint list, two dropdown cascade options are connected to each other.  When I connect my Power Bi report to Sharepoint and transform the data the fields show as a list without any data in them. When I look at the SharePoint list I can see data in the fields. How do I see the data in the Power Bi report from the SharePoint fields.?

Thanks

[amitchandak]

@Elliottd , If you open that in power query you should get an option to expand those lists. There will be an icon near to column name. try that

[Elliottd]

I seem to be getting myself a little confused now. I haven't used power bi or power query before. Any further help?

Thanks.

[v-jingzhang]

Hi @Elliottd 

What delimiter do you select when extracting values from list?

I suggest that you delete the last "Changed Type" step first. Then extract values from list type columns. After that, change column data types manually per your need. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.