07-28-2022 08:08 AM - last edited 08-01-2022 12:20 PM
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
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!