Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! I have a table with about 10000 registries. I want to remove the rows that has a column set to null. I have done "Remove Rows -> Remove Blank Rows" twice. The first time it did remove a few, but the second time it didn't, and I still have many blank rows. Do you know why this might be happening and how can I remove all of the blank ones?
Thanks! Regards!
Solved! Go to Solution.
When you filter values out of a column in the query editor, it's essentially the same as deleting them. Those values will not be loaded to your data model, which will have the benefits of decreasing your load time and having fewer rows to process your calculations against.
When you filter values out of a column in the query editor, it's essentially the same as deleting them. Those values will not be loaded to your data model, which will have the benefits of decreasing your load time and having fewer rows to process your calculations against.
That worked perfectly! Thanks! 😁
Hi @Fátima :
Click on the status bar and "Column Profiling based on the entire data set"
Hope it helps, Please mark my answer as solution
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |