Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hi I've been using this line of code to rename the columns of a JSON nested table for years - all of a sudden it has stopped working and now when I run it it converts all of the RECORDS in the column to LISTS. I feel it is either a bug or a really simple solution.
= Table.TransformColumnNames(#"Expanded Column1.fields", each #"Lookup Function"(Text.BeforeDelimiter(_,"."),Text.AfterDelimiter(_,"."),JiraFields,"Column1.id","Column1.name"))
The error message returns on subsequent steps, which would have formerly expanded the Records into Tables
Expression.Error: We cannot convert the value "[List]" to type Table.
Details:
Value=[List]
Type=[Type]
Difficult to help you without seeing the JSON data it is working on.
Regards
Phil
Proud to be a Super User!
It seems to have resolved itself. 😐
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.