Connecting to Dataflows via DirectQuery from PBI Desktop

[snowrider1799]

Hi guys,

Is there any steps to connect to PBI Dataflows via Direct Query?

I have the following settings configured (enhanced compute engine settings) in the Dataflows, but how do I connect to it without importing my Dataflows into PBI Desktop?

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-directquery

[amitchandak]

@snowrider1799 , I think that is doc for reference

https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-directquery

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

https://thewincentral.com/how-to-enable-direct-query-support-for-power-bi-dataflows/

[snowrider1799]

Hi @amitchandak ,

Thanks. But can you show me from PBI Desktop, how to connect to it? using direct query to connect to pbi dataflows.

All the 3 links you've provided did not mention or show connecting from pbi desktop.

[AllisonKennedy]

It was preview feature in May Desktop release:
https://docs.microsoft.com/en-us/power-bi/transform-model/service-dataflows-directquery

As per the second link that @amitchandak has already posted, you need to enable it first in the Power BI Service with PREMIUM capacity, then it should be available in Desktop:
https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-direct-query-support/

What license do you have for Power BI?

https://powerbi.microsoft.com/en-us/power-bi-premium/

[snowrider1799]

Hi @AllisonKennedy 

I'm having premium workspace. And I've done the configuration.

I open my power bi desktop, but i don't see the direct query to pbi dataflows. Can you screenshot to me? 

[parry2k]

@snowrider1799 there are few more steps you need to make sure to do before using Dataflow with DQ:

- after you turned on Enhanced Metadata on dataflow, you need to refresh the dataflow.

- also make sure  "store dataset in enhanced metadata format" is turned off:

and you will get the option to use DQ or Import

Keep in mind this all is in Preview mode and will change with time.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡