Hey experts.

I have a tricky one for you.

I have access to power query but read-only access to native server, so I can't create views in SSMS - fml.......

I use Power BI query folding as my initial step to push most of the ETL back to the server, however sometimes I only want to grab region 6, sometimes region 5, sometimes region *

My query fold includes WHERE in which I specify my region. The problem is that this is static, so I would like a PBI parameter to control this so that if I go into power query, change the number, then hit refresh, I draw out a different subset (or all) of the data.

Is there a way I can assign a parameter in power query and assign it a value, then use that WITHIN the initial query fold.

For example something like this:

" SELECT * FROM a WHERE REGIONID = " & [powerbi parameter] & ";" "

Thanks for any help you are able to provide!!