Datamart vs Power BI Dataset

Hey nilimarodrigues ,

There are plenty of sites out there doing the "difference between datamart and dataflow" so I am not going to put a bunch of those links in here.  That said, to me, the big difference is the SQL part and then the ability to use the output from the datamart in more robust ways within Power BI.  I use Direct Query to the DataMart and am still able to do a large number of measures in the visual side but also many column modifications within Power Query that are not available to the DataFlow model.

I also believe (no inside knowledge) that the DataMart will continue to become more and more robust and have many new features added to it that will make it even easier to use going forward.

To clarify, if I understand part of your question, correctly....  is that you can create your dataset in Power BI Desktop.  You can probably do part of it (if not most of it) in a Dataflow as well.  However, my opinion is that the Datamart is the place to be (for the future in particular).