Forum Discussion
Removing rows based on values
Hi Anonymous ,
In Power Query Editor, just click on the dropdown next to the column name and de-select the value you want to remove.
This example removes 30122:
Hello djurecicK2,
I know but the fact it that this is only filtering, not removing and tghe values are still usable on the report.
I just want the rows to dissapear so it doesn't affect my report anymore.Thanks !
Hi Anonymous ,
This is not possible, and Power BI does not add or delete data from the data source. If you want to delete rows, it's best to go to the data source.
If filtering affects the use of your report, I recommend that you filter after you import the data so that subsequent steps are not affected.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What do you mean "still usable on the report"?
If you filter in the Power Query Editor, that row is removed. When you Load back to Power BI, that row no longer appears.
