Power BI dataflows vs datamarts: What's the difference???

Are you excited about datamart in Power BI? What about dataflows? Should you even use dataflows anymore? Do we just datamart all the things? Let's have a look!

Introduction to datamarts

Comparing dataflows to datamarts

When to use dataflows

Dataflows with benefits


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #datamart #GuyInACube

[FrankPreusker]

Good job Adam! The next logical video would be to position Datasets vs Datamarts. I see many overlaps here (eg data modeling, live connect/direct connect, ...) and I would appreciate your views in one of the next videos :-)

[YannickPauwels]

Great video describing the pro's, cons and considerations regarding datamarts & dataflows

[torsteinzahledvardsen]

Adam, this is rampage awesome videos!! You bring clarity to the world, tytytyty

[nilswtal]

Nice video. However, I did'nt really get the huge difference to a dataset besides the web-application stuff. Would be great to hear more about the differences (without targeting Apple users with the web part) as DM is a premium feature while datasets are already available with Pro!

[komanguy]

This video makes me want to know more on datamarts! It seems to be the missing feature in power bi service to enable us to create measures and relationships on the web! I’m going to check it up. Thanks a lot for this brief but useful description.

[hankoswart]

Thanks Adam, but reading through the comments there seems to be confusion (which I share) around the difference between datasets and datamarts

[josejoseph]

Nice presentation on Dataflow and Datamart. Thank you

[anderpaim]

Hey Adams, i hope that to be very well!!!
It could very well have generated an objective video of the differences (PROS and CONS) of using datasets, dataflows and datamarts
😎😎😎

[williamsanzvivanco]

Basically a PowerQuery Online in which you can integrate multiple DataFlows.
Maybe as a Power BI Dataset connection but without the DirectQuery limitations.

An alternative as DataVerse, but integrated on Power BI with PowerQuery Machine.

All of that.

[Chris-gtob]

I would love to see more videos about datamarts and practical use cases!

[coolblue]

Great revision of the use cases for dataflows, would like to see a more detailed run through on datamart scenarios. I thought you were a bit lighter on that side of the comparison.

[LandscapeInMotion]

Thanks Adam - Datamarts: Apart from a new great UI experience, and the “all in one” area for modeling and reporting, and SQL DB - I really don’t see the point. I mean, it’s a premium product, so why would use Datamarts when I have the power of Dataflows?? Perhaps MS need to put Datamarts into the Power BI Pro license - would make HEAPS more sense!!

I guess if Microsoft are trying to phase out Power BI Desktop, then this is a step in the right direction!

[zQxLT]

MS could have released more advance ETL features into Dataflows with bug fixes instead of releasing this Datamart

[massimocolaceci]

Hi Adam, thanks for the great video. I wonder how a common scenario (staging dataflow --> transformations dataflow) could be implemented with a datamart. Thanks

[robertbarkovicz]

Adam, can you recommand a scenario of how to use dataflows and datamarts for an efficient way with incremental load?

[jonathanriver]

Thanks, Adam for this video. I think that would also make sense to compare datamart vs datasets since they are more alike. Is that something we can see in the future, please?

[thomasivarsson]

I don't like that MS apprehends a well known architecture part like data mart. This creates a lot of confusion about the product. A data mart is usually a db on top of one or several DWH. All demos I have seen of Power BI DM use databases with integrated dimensions keys. Power BI DM is not a data integration tool but it can create DM on top of sources with keys and granularity integration.

[topcataj]

Feeling even more confused after this. It's so hard to understand and navigate the different options that are available. SO many different tools, things that change over time, I have no idea how we're meant to construct a sensible enterprise environment form this stuff. I've been trying to find out about dataflows and there are serious limitation like only the owner being able to edit them, now I'm wondering if it's the right thing to use but between DAX, Power query, power query online via dataflow, data marts, data lakes/warehouses, fabric etc... I am completely lost

[AgulloBernat]

Data marts can also be like a Premium Dataflow with enhanced compute engine one, but now you can really check if your transformatiaons downstream are folding or not

[amritpriadarsy]

In datamart, I am not getting the option of Power BI dataset in get data option.