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 all,
I've read the newest blog post about dataflows (this one), which states that staging should be disabled for any queries that don't need it by disabling the "enable load" checkmark.
I created a dataflow with dimensional tables. Very few transformations, so staging is not needed.
But after unchecking enable load for all tables, I get the following error:
"A dataflow must include at least one query enabled for loading."
So even if staging is not needed, Fabric is forcing me to enable it for at least one table? What's going on here?
Solved! Go to Solution.
Hello @Noeleke1301,
Forgive me: The blog was publised quicker than the time it takes an update to the behavior you mentioned, to allow publishing Dataflows Gen2 with no load enabled queries, to reach production.
The ETA for the change to be available in most production regions by end of next week, and all production regions by end of July.
In the meantime, the simplest workaround would be to create one query that is load enabled (for example, a table with 1 value). I will ask to update the blog to reflect when the feature will be avilable. as stated here.
Thank you,
Ben
Hello @Noeleke1301,
Forgive me: The blog was publised quicker than the time it takes an update to the behavior you mentioned, to allow publishing Dataflows Gen2 with no load enabled queries, to reach production.
The ETA for the change to be available in most production regions by end of next week, and all production regions by end of July.
In the meantime, the simplest workaround would be to create one query that is load enabled (for example, a table with 1 value). I will ask to update the blog to reflect when the feature will be avilable. as stated here.
Thank you,
Ben