How to remove certain values in Powerbi from CSV files linked in a Sharepoint map

[Gerlinda]

I have linked a sharepoint map to Powerbi with 2 CSV files in it.

In each CSV file there are a couple of rows with certain values that need to be deleted to get the data right.

Is there a easy way to remove the rows certain data from each CSV file which is uploaded to the sharepoint map in Powerbi?

The data in de CSV's may not be changed.. So i cant do it in the CSV files.

Thanks in advance

[themistoklis · Accepted solution]

@Gerlinda 

Best if you remove the rows during the load of data using Power Query.

You can either filter the data based on specific column values by clicking the down arrow icon in column heading.

Or you can use the remove rows button.

See image below: