Dynamic parameters from SQL Server · Direct Query

[Anonymous]

Hello,

I'm need to do some Dynamic queries with parameters.

1.- Power Querty parameter defined as:

2.- Dynamic table import: dimCountries, pais_id the key field.

Power M syntax: 

let
    idpais = Number.ToText(pais_id),
    tmp_param = Text.Combine({"select * #(lf)from dim_paises #(lf)where pais_id > ", Number.ToText(pais_id)}),
    Source = Sql.Database("sd03053", "MKTPBI", [Query = tmp_param])
in
    Source

3. Table: parameterLink = GENERATESERIES(1,999,1)

4. Modelling:

----

I need to choose a value from parameterLink table to perform a Direct Query and retreive the rows from dimCountry (pais_id) that are > to that parameter value.

Example: if I choose parameterLink = 17 then table must show results only starting from 'Andorra'

The main problem is... that it doesn't work.

Thanks!

Luis

[amitchandak · Accepted solution]

@Anonymous , As far as I know, Dynamic M parameter is not supported for SQL server 

check

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