Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
79 | |
58 | |
35 | |
34 |
User | Count |
---|---|
99 | |
59 | |
56 | |
46 | |
40 |