Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have one query like,
let
SomeText = " AND ( " &
(
if SomeParameter= "All" then " 1=1 "
else if SomeParameter= "1" then " T.Column BETWEEN 1 AND 10"
) & ") "
in
AgeText
Then I right click and Create function.
Now I have another direct query when I call this `FunctionI(SomeParameter)`, I get `This query contains transformations that can't be used for DirectQuery.`
Solved! Go to Solution.
Hi, @iqb ;
This is a limitation of DirectQuery mode, I am afraid that you need to switch to Import mode to make the function work.
Also, you can check if this funtion needs to be modified to the following:
let
SomeText = " AND ( " &
(
if SomeParameter= "All" then " 1=1 "
else if SomeParameter= "1" then " T.Column BETWEEN 1 AND 10"
else null
)
& ") "
in
SomeText
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @iqb ;
This is a limitation of DirectQuery mode, I am afraid that you need to switch to Import mode to make the function work.
Also, you can check if this funtion needs to be modified to the following:
let
SomeText = " AND ( " &
(
if SomeParameter= "All" then " 1=1 "
else if SomeParameter= "1" then " T.Column BETWEEN 1 AND 10"
else null
)
& ") "
in
SomeText
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Even Table.FromList is failing in Direct Query
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |