Pre-Filtering Data before Importing

[kdkimble]

I have a table in a SQL Server and I want to filter before bringing into Power BI Desktop.  The reason is that I need uinque information in order to joing to another table.  Currently whey i try to match up via part number it won't let me.  I belive that the part number is duplicated in the table that I am bringing in due to multiple companies.  So I need to filter to just that company before bringing in. 

I know that I can fitler after the fact, which I did, but it won't let me join.  

So I have 2 choices:

1)Create SQL View of data that is filtered to that company

2)Filter before bringing in, but not sure of the syntax or how to do that.

Any help would be greatly appreciated.

[vanessafvg · Accepted solution]

you could also write a sql native query to filter data out (which is the same as a view but you dont have to create a view) which you can paste in the advanced section when you do a get data

[kdkimble]

Thanks for the suggestion.  Appreciate it.