Forum Discussion
Unable to use DirectQuery mode in Dataflows
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.
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,
3 Replies
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,
Hi ibarrau,
We are having Gen2 Storage account with premium capacity. Switched on enhanced computing too, still not working.
TIA
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://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.
