Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm trying to use custom functions and parameters to dynamically load data from SQL Server with DirectQuery. The problem is that when I try to add a column to a query created with DirectQuery I get the message "This step results in a query that is not supported in DirectQuery mode".
Is this a limitation for DirectQuery? Is there any workaround for this?
Thanks and best regards
Jorgen
Solved! Go to Solution.
@Jorgen,
I can reproduce your issue. This is a limitation of DirectQuery mode, I am afraid that you need to switch to Import mode to make the function work.
Regards,
Lydia
@Jorgen,
Could you please share the function you create and describe more details about the parameter?
Regards,
Lydia
Hi,
I connect to sql server with DirectQuery and add a query like "select value from table where value = param", the parameter is a simple text value created with New Parameter (type=text, suggested value=any, current value=some value)
I use create function to convert this query to a function.
Then I connect to another table in the same sql server db which contains the parameters.
I want to add a column with the the custom function to the parameter table so every parameter can trigger the query and retreive the values for the particular parameter.
The problem is when I select Add Column -> Invoke Custom Function, I get the error message: "This step results in a query not supported in DirectQuery mode". Adding a custom column with no function seem to work fine, at least no error message.
Thanks,
Jørgen
@Jorgen,
I can reproduce your issue. This is a limitation of DirectQuery mode, I am afraid that you need to switch to Import mode to make the function work.
Regards,
Lydia
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
41 | |
30 | |
26 | |
21 | |
17 |