Get & Transform with a parameter from Access query

[udigold1]

Hi there,
I was wondering how can I use a parameter in a query using the "Get & Transform" .
For simplification purposes, I have a saved query called 'dbQuery':

select * from Balances where Balances.CoprID=[Idpara]

IdPara is the parameter.

"Get & transform" doesn't recognize this query because it has a parameter and I know I have to drop the parameter so that "Get & transform" will recognize it.
But how do I use it to get the same result as if I were using the parameter?
Thanks,

 

[theBardd]

Pull back all of the data from Balances and then use Power Query to filter to your required CorpId.