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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Import only Non English contained rows and blanks and delete remaining

I have an excel sheet as below and i want to import only chines names and blanks into power bi and delete remaining rows.

 

Excel Sheet data:

-----------------

 

IDName
1shiv
2kumar
3 24567
4谢谢
5你好
6明天见
7 

 

Data in Power BI should look like:

---------------------------------------

 

IDName
4谢谢
5你好
6明天见
7 

 

in the given example above i have shown few records but i have millions of rows to do this.

1 ACCEPTED SOLUTION

@Anonymous

 

Sorry I had missed the null

 

File attached as well

 

try this

 

= Table.SelectRows(#"Changed Type", each List.ContainsAny({"",null}, {Text.Select([Name],List.Transform({1..126}, each Character.FromNumber(_)))}))

View solution in original post

4 REPLIES 4
Zubair_Muhammad
Community Champion
Community Champion

Hi @Anonymous

 

Try adding this step in Query Editor

 

It works with your sample data

 

= Table.SelectRows(#"Changed Type", each Text.Select([Name],List.Transform({1..126}, each Character.FromNumber(_)))="")

 

See the attached file

@Anonymous

 

Sorry I had missed the null

 

File attached as well

 

try this

 

= Table.SelectRows(#"Changed Type", each List.ContainsAny({"",null}, {Text.Select([Name],List.Transform({1..126}, each Character.FromNumber(_)))}))
Anonymous
Not applicable

Thank you so much @Zubair_Muhammad it worked.

However, i didnt get this trasform List.Transform({1..126) that how it works?. if possible, pls explain.

Thank you again for swift response and help 🙂

@AnonymousThis function results in a list of majority of characters that we can type from the keyboard

 

List.Transform({1..126}, each Character.FromNumber(_))

 

Create a blank query and cope paste above code you will get

 

china.png

 

 

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! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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