Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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
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.
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
Check out the July 2025 Power BI update to learn about new features.