Forum Discussion
Gen2 Dataflows - Again appear to have serious issues.
- 2 years ago
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.
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.
Hi MartinMason ,
I would like to check once again with you, whether your issue was resolved? Or still support team is looking into your issue?
Incase if any help is required from my end, let me know.
Thanks,
Gopi Krishna Chenna
- MartinMason2 years ago
Resolver I
It's been resolved. It's impossible to create the situation I was running into two days ago because now when you try to publish a dataflow and a function is created with Enable Staging checked (option was disabled for functions two days ago), you get an error that at least one of the queries in the dataflow does not contain a schema.
- Anonymous2 years agoNot applicable
Hi MartinMason ,
Glad to know your query got resolved.
Please continue using Fabric Community for your further queries.