Forum Discussion

chahineatallah's avatar
chahineatallah
Helper III
4 years ago
Solved

difference between dataflows and datasets?

Hello I have this question, when to use dataflow & when to use dataset? from my understanding dataset contains data+transformations for data +relationships+dax etc, so when i upload my model it bec...
  • amitchandak's avatar
    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