Forum Discussion

Teige_Gao's avatar
Teige_Gao
Frequent Visitor
6 years ago

Direct Query on Dataflow

Hi all,   When can we set up the direct query on Dataflow? It looks like that all data are imported into dataset when we use dataflow.
Dataflow
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
5 years ago

v-xuding-msft 
Please advise:
I am unclear what the Direct Query option in Power BI Dataflows offers me. From what I understand it looks like this addresses the connection between the Power BI dataset and the dataflow. Does this also extend to the connection between the dataflow and the source database?

I have a use-case where I would like to direct query the source, is this scenario supported in Power BI Dataflows using Direct Query mode? (i.e. is (2) supported from the descriptions below?):

  1. Direct Query from Power BI to Dataflow, but that the dataflow is still on a scheduled refresh, i.e. I have a ‘live’ connection to the dataflow, but this dataflow is only refreshed at a schedule;
  2. Direct Query from Dataflow to Source, i.e. the dataflow queries the source at request and therefore my data is ‘live’ w.r.t. the source.