07-28-2022 08:08 AM - last edited 09-07-2022 09:02 AM
Welcome to the Power BI Community Show! This is a live show hosted by Kelly Kaye, the Community Engagement Lead for Power BI. She is passionate about the Power BI Community, is the founder of the Power BI Women User Group, and a Power BI developer.
On this episode, Kelly Kaye interviews Priya Sathy and Charles Webb from the Power BI team, who will discuss and demo Datamarts.
Connect with Kelly on Twitter @MS_KellyKaye
For more information on Datamarts, visit aka.ms/datamartdocs
To read Power BI Product Blogs, visit https://powerbi.microsoft.com/en-us/blog/
Each Power BI Community show features different topics, speakers, and giveaways celebrating the awesome Power BI Community. We invite you to join us for this and past episodes.
Post your comments on https://aka.ms/PBIShowComment, so we can contact you if you are selected for a giveaway item!
• Register on the Power BI Community: https://community.powerbi.com/ for fun giveaways
• Connect with a Power BI User Group: https://aka.ms/PowerBIug
• Check out past episodes of the Power BI Community Show: https://aka.ms/PowerBIShow
• Power Platform Conference: https://powerplatformconf.com
I would very much like the ability for the visual and/or SQL queries saved on top of the model to be available as their own entity and show up as tables that can be pulled into Desktop.
It's great to be able to slice the data with SQL, but if we aren't able to actually leverage them....then DAX integration is that much more important. I personally believe two PBI user types will emerge if both of these come to fruition, those who use SQL and those who use DAX. Whether that's a good thing is impossible for me to say with any degree of certainty.
I would love to see when using datamarts as a source in desktop, I'd like to choose which mode I'd like to pick (import/DirectQuery) since there truly are some limitations that exist in relation to DAX. This wouldn't be such a big deal if there was an easier way to bulk load DAX measures, calculated columns and calculated tables.
An external tool that enables you to publish a desktop model to a datamart, similar to the way json can be imported or uploaded to create data flows.
Thank you again for the presentation!
Datamarts seem to be a great add for it savvy business users or national analytics guys!
Will present the option to those guys!
Power BI socks are great too!
I have a deeper question on datamarts from my inchat on import vs direct query:
I have a complex report that imorts SQL, 80+ excel files and a sharepoint list, and uses Power Apps as a writeback for living data. The writeback excel file is folded back into the initial data table for multiple reasons (main being Power Apps can not query nulls - ugh) before it goes through an 800 line power query transformation and calc column transformation.
I'm wondering if it's possible to do this in a datamart, or if my current use of Power Query is the better way to manage (the work I've accomplished with the writeback and auto paginating derivative reports the bosses are thinking of more projects so wondering for the next round)>
Loved the clarification on Datamarts pricing. Still unsure of the exact target audience. I see pro ETL guys more like to use Databricks and SQL to shape data, and read data out of Synapse Serverless. Priya did a great job.
We are just about to start, so be sure to post your questions here.
We are also giving away Power BI socks today, just let us know what was your favorite demo.
Thank you for reaching out. The show will be live on Monday, August 1 at 11 am PDT. The good news is that you don't have to register! You can join us here on Monday. I hope to see you then!