Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JM_
New Member

Table.TransformColumnNames seems to turn Records into Lists - this code previously didn't do this

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]

2 REPLIES 2
PhilipTreacy
Super User
Super User

@JM_ 

 

Difficult to help you without seeing the JSON data it is working on.

 

Regards

 

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


It seems to have resolved itself. 😐

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.