Forum Discussion
Datamart vs Power BI Dataset
Thank you collinq for your response. Appreciate it. I think my question is mainly on Power BI dataset vs Datamart. Except for the SQL part, Power BI dataset already does provide all the capabilities that you can have with Datamart - joining multiple sources, creating measures etc and you can also use one dataset for several reports. And hence wondering, is Microsoft pushing us to use Datamart instead of power BI dataset or what exactly the game plan here?
Hey nilimarodrigues ,
You are right that the dataset in a file can be published and shared. I believe that the thought behind datamarts is to build the basic dta model for folks and then let them build their own appropriate datasets from that point. Whereas, a dataset is a preset data model that is "baked" already inside a Power BI file.
So, it is not really about "who can use it" as much as it is about "what variability does the user have with it" perspective.