Forum Discussion
Query Folding in Dataflow ignored by pbix
Hi Tim,
I'm a little confused about what you're expecting to happen when you connect to the Dataflow in the PBIX file.
Also, I have questions.
- Is the Dataflow in a Premium or PPU capacity?
- Is the 'Enhanced compute engine' turned on for the Dataflow?
- Are you using the PowerPlatform.Dataflow connector in the Dataset?
- Is the table you are pulling into the PBI dataset from the Dataflow a computed table?
If any of these criteria (there may be others) are not met, chances are, the query folding won't happen.
If you've set the Dataflow table as import mode in the dataset, query folding will be largely irrelevant without filters or incremental refresh setup on the Dataset.
Just because the 'View Native Query' is greyed out, it doesn't mean folding isn't happening.
Hopefully some of this is helpful. Let me know if you have questions.
Hi Tim,
I'm a little confused about what you're expecting to happen when you connect to the Dataflow in the PBIX file.
Also, I have questions.
- Is the Dataflow in a Premium or PPU capacity?
- Is the 'Enhanced compute engine' turned on for the Dataflow?
- Are you using the PowerPlatform.Dataflow connector in the Dataset?
- Is the table you are pulling into the PBI dataset from the Dataflow a computed table?
If any of these criteria (there may be others) are not met, chances are, the query folding won't happen.
If you've set the Dataflow table as import mode in the dataset, query folding will be largely irrelevant without filters or incremental refresh setup on the Dataset.
Just because the 'View Native Query' is greyed out, it doesn't mean folding isn't happening.
Hopefully some of this is helpful. Let me know if you have questions.
Hi KNP,
Thanks for the reply. I was about to answer YES to all your questions when I realised that Enhanced Compute Engine wasn't turned on. Once I turned this on and refreshed the dataflows, the View Native Query became available. I have previously had this setting turned on and forgotten about it when I deleted the dataflow and re-created it.
Thanks again for your help.
regards, Tim.