Exploring the preview of datamart in Power BI!

We take a look at the newly announced preview of datamart in Power BI! A no code experience to build a relational database for analytics right inside Power BI!


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

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

[iampresent.digital]

Question: is there still a place for dataflows? What is the best practice? Setting up a datamart to import data from an on prem sql server? Or keep using dataflows and then plugging datamart to it? Which is more efficient?

[twitchyfingerss]

I'm super excited because my company uses both PowerBI and Tableau. I can do my ETL in Power BI, have some PowerBI reports, and reuse the same ETL in Tableau visualizations in those departments that are on Tableau! We don't have anyone in IT to do ETL, so I'm doing it on the side as a business user.

[MatthewRoche]

Love it!

This is the most complete and concise introduction to datamarts that I've seen to date. Very well done!

[datacentric]

Great for democratizing data but how do we avoid this being another data silo.

[shehzeervp]

Does this mean we don't need to create pbix files for data sets? For me it sounds like most of the development we do in pbi desktop can be eliminated, and especially the "download/publish pbix" cycle.

[swerick]

Wow, this is really cool. Connecting with SSMS, etc. and SQL is a real game changer.

[kaeldowdy]

Question ??: wondering about use-cases for PBI datamarts. The Cube Guys gave an example of a datamart being set up for a business area for that department's own use. What about taking a datamart approach to centralize core datasets to support all enterprise PBI reporting? What would be the pros/cons in that use case vs. using dataflows?

[tszreder]

This looks almost too good to be true :) One question though: can you use datamart as a source for building another dataset? E.g. to combine data from different datamarts (and datamarts becoming a kind of reusable ETL just like dataflows :))

[sirlanceohlot]

Thank you Adam & Patrick for diving into this in a way that is straight to the point :)

I am excited for datamarts in Power BI as I can see this being a boon for our newer international offices where they don't have all of the bells and whistles we have in our US offices!

[AlexisVal-mb]

Hello! Great explanation, i have a doubt. Why are you saying that now calculated tables are not needed anymore because we have sql queries? the queries i create cant be used in the model, they are just for analizing the data. What am i not understanding?

[Molaa]

Amazing feature!! How do you separate when to build a DW (+SSAS ??) and when to use a DataMart straight into PBI Service?, Does BI / DW Dev + Data Engineers skills are no longer need? or maybe less needed? A Business User with good skills in PQ and data modeling can create a super powerfull datamart without a BI Team?

[rapchak]

Hey guys! Love your videos! Great explanation here. Question for you, I stood up a Datamart for a client and was wondering how each query executes. With individual flows, I can schedule each to run concurrently. If one fails, the rest still run. Do Datamarts function in a similar fashion? Similarly, if I do not want to refresh specific queries (think master data connected to csv on SharePoint) when the model refreshes, is this possible?

[zoloturu]

Question: Is there any way to do version control of Datamart? If somebody deletes it how to recover that?

[oscaranibalhernandez]

I watched the presentation on Microsoft Build 2022 thinking I hope GuyInACube talk about these tomorrow
but you do not wait for tomorrow huh?

[AHMEDALDAFAAE]

Thank you for this video!! However, I have questions:
- Do we need a gateway for datamarts syncing? If no, that will be great in fact
- Can we do ETL on an existing Azure SQL database?If yes, this feature is a revolution !!
I think the only situation we need on-prem gateway is when use have data behind a VNET, please correct me if I am wrong!
Thank you again!!

[christinateilmannknudsen]

Very cool! But wonder how it affects the capacity and performance of other reports within that capacity?

[seanoloughlin]

While this seems cool, I’m not sure if the common business user would see much more benefit from connecting to this versus a shared power bi dataset. Main difference I can see is the SQL server access, anything else?

[ashdam]

Whats the difference between this and creating a dataset?

[jessecrammer]

Is there any ideas on when this'll be out of preview? I love the Azure SQL integration!

[robscheffler]

This is bananas! Will we be able to *easily* copy over existing Power BI desktop queries into the Datamart? Or even import an entire model (including all measures)? Like other commenters, I'm excited to push more of the power query ETL workload into a server and free up my local machine to do...well, I'll figure out something else for it to do!