Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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