Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @Markzolotoy
The answer is simply no, you can't use SQL statemants in DQ mode, it needs Database.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
What does it mean "requires database"?
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |