when to use power bi dataset and when to use power bi dataflow?

[komald]

i need your suppoort to understand power bi dataset vr dataflow

[v-jingzhang · Accepted solution]

Hi @komald 

Power BI dataflow is Power Query Online. It can do what you do with Power Query Editor in Power BI Desktop. It is used to connect to data sources, transform and filter data, combine multiple queries, etc. It deals with the ETL process of data. It doesn't include data model (relationships between tables, measures, calculated columns, calculated tables). However a Power BI dataset has data model in it. 

You can refer to this article to learn more differences between them: Power BI Datamart Vs. Dataflow Vs. Dataset - RADACAD . Power BI Datamart is newly introduced in this year. You may have an interest in it.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[keshavagrawal27]

Hi @komald,

Please reffer the below article for the same:

https://community.powerbi.com/t5/Service/When-to-use-Dataflow-vs-Dataset/m-p/2238793

Please mark my answer as solution.

Regards,

Keshav Agrawal