Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Re: Power BI Community Show Episode 9 - Datamarts and New Power BI Community Features

07-29-2022 08:13 AM

Barbuckles
Advocate I
7087 Views
Natalie_iTalent
Administrator
Administrator

Power BI Community Show Episode 9 - Datamarts and New Power BI Community Features

‎07-28-2022 08:08 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!

 

Show Links:

• 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

 

 

 

 

 

Message 1 of 18
7,190 Views
Inspired-Steve
New Member

‎08-18-2022 11:00 PM

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. 

Message 18 of 18
3,849 Views
0
Inspired-Steve
New Member

‎08-18-2022 10:52 PM

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. 

Message 17 of 18
3,863 Views
0
Ranga_naik
Regular Visitor

‎08-17-2022 03:50 AM

Very  Informative session 

Message 16 of 18
4,023 Views
0
Anonymous
Not applicable

‎08-02-2022 01:30 AM

With regard to Datamarts, where do you see DAX in the future if Datamarts will be using SQL?

Thanks 🙂

Message 15 of 18
5,348 Views
0
OkanBulut
New Member

‎08-01-2022 01:04 PM

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!

Message 14 of 18
5,467 Views
TERRY_HUGHES
Frequent Visitor

‎08-01-2022 11:54 AM

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)>

Thanks!

Message 13 of 18
5,488 Views
parishdapbi
Advocate II
Advocate II

‎08-01-2022 11:39 AM

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.

Message 12 of 18
5,508 Views
tom480
Resolver I
Resolver I

‎08-01-2022 11:30 AM

 I love socks !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Thanks again!

Message 11 of 18
5,524 Views
J_Sekellick
Advocate I
Advocate I

‎08-01-2022 11:22 AM

Great update. Looking forward to using the Datamart.

Message 10 of 18
5,529 Views
tom480
Resolver I
Resolver I

‎08-01-2022 11:12 AM

Great session today!  Thank you!

Message 9 of 18
5,545 Views
AJ_J
New Member

‎08-01-2022 11:10 AM

Super excited about Datamarts!  Would love to see a one-pager or the like and perhaps a product roadmap! (For those of us that are early adopters 😄 )

Message 8 of 18
5,553 Views
eileen_iTalent
Administrator
Administrator

‎08-01-2022 11:02 AM

Welcome Everyone!

 

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.

Message 6 of 18
5,579 Views
tom480
Resolver I
Resolver I
In response to eileen_iTalent

‎08-01-2022 11:44 AM

I really enjoyed the entire show but the quick walkthrough on datamarts drag and drop was AMAZING!!!

Message 7 of 18
5,498 Views
Natalie_iTalent
Administrator
Administrator

‎07-29-2022 08:22 AM

@Barbuckles,

You are welcome!  It will be a great episode!

 

Best,

Natalie H.

Community Manager 

Message 5 of 18
7,079 Views
0
Natalie_iTalent
Administrator
Administrator

‎07-29-2022 08:16 AM

Hello @Barbuckles,

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!

 

Best,

Natalie H.

Community Manager 

Message 3 of 18
7,085 Views
Barbuckles
Advocate I
Advocate I
In response to Natalie_iTalent

‎07-29-2022 08:19 AM

Awesome! Thanks for responding so quickly. Looking forward to it.

Message 4 of 18
7,082 Views
Barbuckles
Advocate I
Advocate I

‎07-29-2022 08:13 AM

I'm a little confused how to register? The link just takes you back here.

Message 2 of 18
7,087 Views