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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SonLeThai
Frequent Visitor

REMOVE RECORD ON LIST IN POWER EDITOR

Please help me!!!

I have List contain Record like that: {"a", [{a1,a2}, {b1,b2}], "b", [{a1,a2},{d1,d2}], ""}

a
Record
b
Record
""

I want to remove Record on list and return it by text, result:

a
b
How can I do that?
Link file example:
https://drive.google.com/file/d/14Ckb0rFQR0zAnQXQA4ahQvaCQolsFBqg/view?usp=sharing 

1 ACCEPTED SOLUTION

Hey @SonLeThai ,

 

make the Json file available as well, this is required because I'm going to clean the record inside Power Query.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

4 REPLIES 4
TomMartens
Super User
Super User

Hey @SonLeThai ,

 

please create a pbix that contains sample data, upload the pbix to onedrive, Google Drive, or Dropbox, and share the link.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hey @SonLeThai ,

 

make the Json file available as well, this is required because I'm going to clean the record inside Power Query.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

tks you!!

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

October NL Carousel

Fabric Community Update - October 2024

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