Forum Discussion
Dataflow gen2 using variables from Variable Libraries Failing
Hello TLibson,
I will check the variable queries first. For those queries, are staging and output disabled?One thing worth checking is staging on the variable queries. Microsoft suggests turning this setting off when you’re using Variable.ValueOrDefault().
Another choice is to compare the Workspace and Lakehouse IDs in your variables with the ones returned by Lakehouse.Contents(). If they are not matching, then that mismatch might be the reason you are getting the key error.
Check the GUID casing too.
If those match, I will then look at the destination query and table navigation.
Microsoft docs: Variable references in a Dataflow
Super UserHello TLibson,
I will check the variable queries first. For those queries, are staging and output disabled?
One thing worth checking is staging on the variable queries. Microsoft suggests turning this setting off when you’re using Variable.ValueOrDefault().
Another choice is to compare the Workspace and Lakehouse IDs in your variables with the ones returned by Lakehouse.Contents(). If they are not matching, then that mismatch might be the reason you are getting the key error.
Check the GUID casing too.
If those match, I will then look at the destination query and table navigation.
Microsoft docs: Variable references in a Dataflow