Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
96 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |