Applying SQL logic to MS PowerBI

[SusuYes]

Hello all, 

I'm not very expreinced with SQL but I am connected to a database where I can apply a certain logic to get a unique view. I am trying to recreate the same view in PowerBI so that I am able to report on this data. 

The SQL logic is as follows: 

SELECT * FROM TABLE_NAME WHERE COLOUMN_NAME IN ('1',2'); 

I am trying to get the same view in PowerBI but I am not sure how to apply that at the source query. 

[Anonymous · Accepted solution]

Hi @SusuYes 

After you have your basic query loaded in the power Query editor, click on the column header drop down and select only the values you need.

[SusuYes]

thank you, I just realised that it is just a filter haha