Forum Discussion
Power BI data set as direct query pointing to Dataflow
is there a way Power BI data set as direct query pointing to Dataflow.
please let me know if anyone worked on this.
Hi saikumarpadakan ,
To use DirectQuery with dataflows, you must explicitly toggle the enhanced compute engine to On in dataflow settings. You must then refresh the dataflow before it can be consumed in DirectQuery mode.
- Navigate to the Premium dataflow, and set enhanced compute engine to On.
- Refresh the dataflow.
After you complete the steps, the dataflow is accessible in Power BI Desktop with DirectQuery mode.
Below is the official link will help you:
Using DirectQuery with dataflows - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Brunner_BI
Impactful Individual
I dont think this is possible.
Hi saikumarpadakan ,
To use DirectQuery with dataflows, you must explicitly toggle the enhanced compute engine to On in dataflow settings. You must then refresh the dataflow before it can be consumed in DirectQuery mode.
- Navigate to the Premium dataflow, and set enhanced compute engine to On.
- Refresh the dataflow.
After you complete the steps, the dataflow is accessible in Power BI Desktop with DirectQuery mode.
Below is the official link will help you:
Using DirectQuery with dataflows - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
