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?

 

Best regards,

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

     

     

2 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    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.