When Importing a SP list some values display "List" rather than actual value within the list

[Spell]

While importing in transform data, a few columns display "List".  I select the 2 arrows button in top right and select "Extract Values" and selected every delimiter listed, but always results in error, (Expression.Error: We cannot convert a value of type Record to type Text).

How can I pull in the value from the list, when directly linking to the SP List?

I know as a work around if you go directly to the SP list and select "Export to Power BI" which creates a data set then connect to that but I do not like that option.

[v-echaithra]

Hi @Spell ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,
Chaithra.

[v-echaithra · Accepted solution]

Hi @Spell ,

Thank you for posting in Microsoft Community.

This happens when Power BI connects to a SharePoint List, it retrieves data in a structured format.
Try these methods listed here to resolve your issue: Guy in a Cube – How to expand a list of records in a query | Microsoft Power BI Blog | Microso...

If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

Thanks and Regards
Chaithra