Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dataflow import into Pwr BI Desktop

I am trying to use dataflows as a source in a dataset/report and am having confusing problems. Background: I have a dataflow with 4 entities - which are based on Synapse views and spark tables. I am ...
Dataflow
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Microsoft  has  announced Direct Query Support (in preview) for Power BI Dataflows.

    As mentioned by J0S3PH ,with this functionality in place, Power BI users no longer need to import the data into a dataset first, instead can connect directly to a dataflow.

    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 before it can be consumed in Direct Query mode.

     

    For more details, please refer to this document.

    Use DirectQuery with dataflows in Power BI (preview) 

     

    Best Regards,
    Community Support Team _ Eason

     

  • v-easonf-msft's avatar
    v-easonf-msft
    5 years ago

    Hi, Anonymous 

    Yes, any premium capacity would make this capability availible.

    service-premium-per-user-faq 



    Best Regards,
    Community Support Team _ Eason


J0S3PH's avatar
J0S3PH
New Member
5 years ago

Hi - When using import I believe PBI must first read the data in before it can apply the filter. Is your dataflow in a WorkSpace backed by Premium Capacity? If so you could look at enabling the advanced compute engine and utilise direct query.