SQL Select with parameters in DirectQuery mode

[Markzolotoy]

Here is my code:

let
Source = Sql.Database("localhost", "DB",
[Query="select id from table#(lf)where name = '"&Name&"'#(lf)and othercondition = 0#(lf)"]),
id = Source[id]
in
id

I get "This query contains transformations that can't be used for DirectQuery."

Is there a way of running sql selects with PB parameters in DQ mode?

Thanks

[aj1973]

Hi @Markzolotoy 

The answer is simply no, you can't use SQL statemants in DQ mode, it needs Database.

[Markzolotoy]

What does it mean "requires database"?

[aj1973 · Accepted solution]

DQ mode connects directly to the source data stays where it is, it doesn't import the data into Power bi engine/power query to make transformation on it. DQ mode doesn't allow trasformations to be made directly on the source just like Live connection mode.