Forum Discussion

mmossel's avatar
mmossel
Microsoft Employee
5 years ago
Solved

Dataflows vs DirectQuery vs standard ETL

Hi,   What role does Dataflows play in relation to PowerQuery in PBI Desktop and the standard ETL/ELT with which you fill a data warehouse? In which scenario would one choose which tool and why?  ...
Need Help
  • aj1973's avatar
    aj1973
    5 years ago

    Hi mmossel 

    You don't compare Dataflow vs DQ. A Dataflow is a set of entities that you ETL them through online PowerQuery. DQ is a mode of connection to the source and you can compare it to Import mode. here is a comparison Table

     

     

v-angzheng-msft's avatar
v-angzheng-msft
Community Support
5 years ago

Hi, mmossel 

Is the above answer helpful to you? If  so, could you please mark the post which helps , It will help the others in the community find the solution easily if they face the same problem with you. Thank you.