Dataflows vs DirectQuery vs standard ETL

[mmossel]

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,

[v-angzheng-msft]

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.

[aj1973 · Accepted solution]

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