Solved: Dataflows vs DirectQuery vs standard ETL

mmossel · ‎06-06-2021

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,

aj1973 · ‎06-06-2021

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

v-angzheng-msft · ‎06-08-2021

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.

How to get your questions answered quickly -- How to provide sample data

aj1973 · ‎06-06-2021

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

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook