Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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:
-----------------
ID | Name |
1 | shiv |
2 | kumar |
3 | 24567 |
4 | 谢谢 |
5 | 你好 |
6 | 明天见 |
7 |
Data in Power BI should look like:
---------------------------------------
ID | Name |
4 | 谢谢 |
5 | 你好 |
6 | 明天见 |
7 |
in the given example above i have shown few records but i have millions of rows to do this.
Solved! Go to 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(_)))}))
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(_)))}))
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
62 | |
59 | |
56 |