Forum Discussion
difference between dataflows and datasets?
- 4 years ago
chahineatallah , dataflow is for a common set of tables that need transformations and needs to be used across various projects. Dataflow will become a source for the dataset. Dataflow is a set of tables but not model.
Dataset is a model with a Table , relationship, new columns, and measures. It is ready to be used report.
We can have all dimension tables and the small facts and static tables as dataflows and let all global team uses that without knowing what all needed to build those.
Say, for example, I have an article dimension that uses a few sources including excel. So I made a dataflow global dimenions with Article and few other dimensions.
Then I used that in Sales Dataset and Purchase Dataset and allowed sales and purchase team to use dataset to create report
Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA
https://radacad.com/dataflow-vs-dataset-what-are-the-differences-of-these-two-power-bi-components
chahineatallah , dataflow is for a common set of tables that need transformations and needs to be used across various projects. Dataflow will become a source for the dataset. Dataflow is a set of tables but not model.
Dataset is a model with a Table , relationship, new columns, and measures. It is ready to be used report.
We can have all dimension tables and the small facts and static tables as dataflows and let all global team uses that without knowing what all needed to build those.
Say, for example, I have an article dimension that uses a few sources including excel. So I made a dataflow global dimenions with Article and few other dimensions.
Then I used that in Sales Dataset and Purchase Dataset and allowed sales and purchase team to use dataset to create report
Dataflows and Dataset Design Pattern implementation: https://youtu.be/zwhJ1hWPcrA
https://radacad.com/dataflow-vs-dataset-what-are-the-differences-of-these-two-power-bi-components