Forum Discussion
Resolver IGen2 Dataflows - Again appear to have serious issues.
I created a support ticket, 2402060040005927. However, after investigating, think I have identified the root cause. When creating a function, I'm adding a Blank Query and then pasting the M code into the Blank Query definition. That apparently is the root cause. And from that point on, I'm toast. When returning to the dataflow now, the Enable Staging option on that newly created function is disabled, but.....is apparently set to true. And bam, the error is there and cannot be resolved.
To create a function correctly, add a Blank Query and go through without changing. When in the dataflow screen, after creating the let Source = "" in Source query, uncheck the Enable Staging option. Then edit that query with the function definition.
It would be interesting to see if someone else sees the same behaviour in their Fabric tenant.
Resolver II created a support ticket, 2402060040005927. However, after investigating, think I have identified the root cause. When creating a function, I'm adding a Blank Query and then pasting the M code into the Blank Query definition. That apparently is the root cause. And from that point on, I'm toast. When returning to the dataflow now, the Enable Staging option on that newly created function is disabled, but.....is apparently set to true. And bam, the error is there and cannot be resolved.
To create a function correctly, add a Blank Query and go through without changing. When in the dataflow screen, after creating the let Source = "" in Source query, uncheck the Enable Staging option. Then edit that query with the function definition.
It would be interesting to see if someone else sees the same behaviour in their Fabric tenant.
Helper IHey,
Thanks man, you've saved me a lot of time.
Apprently this seems to be an issue (again?) still.
I was getting this issue while using a query as variable e.g.
let
Source = Date.Month(Date.AddMonths(Date.From(DateTime.LocalNow()), -1))
in
Source
​Staging is enabled by Default when creating a blank query but i was in Fact able to just disable staging and fix the issue.However in the PowerQuery Editor it obviously worked fine and just as soon as i hit refresh it published successfully but failed loading.
TLDR; if you're using a custom (blank) query to output anything else than an actual Table you have to disable Staging