Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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. 😐
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.