select rows where field from sql table equals field in power bi query

[Anonymous]

Hi All,

hope I can explain this:

I have an existing query in power BI that lists product id, product description based on a parameter user inputs.

I have a view in sql database that shows all products sold over a timeframe(not relevant)

I would like to get all products sold that match product id from the existing query

I really hope it makes sense, i'll try to visualize it:

existing query has prod ids 'A','B',C'

i want noly the rows from the SQL view that match product ids 'A','B','C'

Any help would be greatly appreciated!

[v-luwang-msft]

Hi @Anonymous ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it.

Best Regards

Lucien

[v-luwang-msft]

Hi @Anonymous ,

The following article may be helpful foryou!You can have a look!

How do I pass parameters to my SQL statement?

How do I pass parameters to my SQL statement?

Best Regards

Lucien

[Anonymous]

yes, i'll give it try thanks!

[amitchandak]

@Anonymous , You want to pass query parameters? Ask is not very clear.

refer if this blog can help https://www.thebiccountant.com/2017/03/22/use-slicers-for-query-parameters-in-powerbi/