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 that when imported, reads something like this
Country City
Canada Toronto
Canada
Canada Calgary
Canada Vancouver
I want to delete rows from this table (at data refresh) where City is null... so that my final table should look like this
Country City
Canada Toronto
Canada Calgary
Canada Vancouver
Thanks
Solved! Go to Solution.
Hi @talhaparvaiz ,
In Query Editor, click button at the column header and click Remove Empty feature.
Best Regards,
Jay
Hi @talhaparvaiz ,
In Query Editor, click button at the column header and click Remove Empty feature.
Best Regards,
Jay
@talhaparvaiz , go to query editor and filter the City column and unselect the nulls in the dropdown.
in Power Query editor you can remove the such rows
watch this short video https://drive.google.com/file/d/1joxWn6FCWlXJ_SdVkZkOCZKUVUezvhti/view?usp=sharing
Proud to be a Super User!
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |