Direct Query based on URL parameters

[SaharMa]

Hey,
I am trying to create an embedded report that receives live data from a SQL server using Direct Query.
I have a parameter that changes the query:

Is it possible to use URL parameter to change the parameter value and thus control the query on demand?

* I'm not trying to just filter the imported data - I'm trying to query just the needed data by the URL parameter value, for example:

https://app.powerbi.com/groups/testReport?filter=scenarioId eq 50

will change the scenarioId parameter value to 50 and the query will look like:

Thanks

[amitchandak]

@SaharMa , refer if this can help

https://docs.microsoft.com/en-us/power-bi/service-url-filters

Also, explore dynamic M Parameters

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters