Forum Discussion
Removing rows based on values
Hello, Didn't found anything that would help me the way I want so I'm posting here. I have an XML import (~10 000 Rows) in my Power Query and I would like to Remove Rows based on the content of...
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.