Unable to use DirectQuery mode in Dataflows

[dekalya]

We have created few dataflows recently, but unable to connect through DirectQuery Mode. We have already switched on Enhanced compute engine settings and reloaded the dataflow. Still unable to use DirectQuery mode while connecting it from PBI Desktop. Kindly help!

TIA.

[Anonymous]

Hi  @dekalya  ,

In order to use this capability, you should be a premium Power BI user.

Enable the enhanced compute engine on your premium plan and refresh the dataflow, and then you can access it in Power BI Desktop with direct query mode.

This is a link to related content, I hope to help you:

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-configure-consume

https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/dataflo...

https://community.powerbi.com/t5/Service/Direct-Query-Dataflows/m-p/1083455

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ibarrau · Accepted solution]

Hi. Have you follow this post? you have to turn two things on and consider that it will only work with workspaces with dedicated capacity.

https://powerbi.microsoft.com/es-es/blog/power-bi-dataflows-direct-query-support/

I hope that helps,

[dekalya]

Hi ibarrau,

We are having Gen2 Storage account with premium capacity. Switched on enhanced computing too, still not working.

TIA