Add Data at Scale | Datamart in Power BI
Datamart is a new self-service capability included with Power BI Premium that reduces the time it takes to do custom departmental reporting, from weeks to minutes. In just a few clicks, both business users and analysts can easily create and access their own mix of data from dozens of the most common data types and services, all backed by Azure SQL that brings elastic scale and ad-hoc analysis to Power BI. Charles Webb, from the data team at Microsoft, joins Jeremy Chapman to show you a Datamart in action.
► QUICK LINKS:
00:00 - Introduction
00:43 - What changes with Datamart?
02:21 - See Datamart in action
05:34 - Analyst experience
06:32 - Complex requests
09:24 - Pull Data with T-SQL
12:01 - Where to get started
► Link References:
For more guidance, check out https://aka.ms/DatamartDocs
► Unfamiliar with Microsoft Mechanics?
As the Microsoft’s official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft.
► Unfamiliar with Microsoft Mechanics?
• As the Microsoft’s official video series for IT, you can watch and share valuable content and demos of current and upcoming tech from the people who build it at Microsoft. Subscribe to our YouTube: https://www.youtube.com/c/MicrosoftMechanicsSeries?sub_confirmation=1
• Talk with other IT Pros, join us on the Microsoft Tech Community: https://techcommunity.microsoft.com/t5/microsoft-mechanics-blog/bg-p/MicrosoftMechanicsBlog
• Watch or listen from anywhere, subscribe to our podcast: https://microsoftmechanics.libsyn.com/website
• To get the newest tech for IT in your inbox, subscribe to our newsletter: https://www.getrevue.co/profile/msftmechanics
► Keep getting this insider knowledge, join us on social:
• Follow us on Twitter: https://twitter.com/MSFTMechanics • Share knowledge on LinkedIn: https://www.linkedin.com/company/microsoft-mechanics/
• Enjoy us on Instagram: https://www.instagram.com/microsoftmechanics/ • Loosen up with us on TikTok: https://www.tiktok.com/@msftmechanics
Published on:
Learn more
Made for tech enthusiasts and IT professionals. Expanded coverage of your favorite technologies across Microsoft; including Office, Azure, Windows and Data Platforms. We'll even bring you broader topics such as device innovation with Surface, machine learning, and predictive analytics.
Related posts
Measuring Geocoding Performance In Power BI Map Visuals Using Performance Analyzer
When a user complains about their Power BI report being slow it’s normal for the developer to open up DAX Studio and start tuning the me...
The Power BI Dataviz World Champs is back!
Join the Power BI Dataviz World Championships – three rounds of visualization challenges, community voting, and a live finale at FabCon ...
Power BI Report metadata defaults to Power BI Enhanced Report format (PBIR)
Starting January 25, 2026, Power BI reports will default to the Enhanced Report format (PBIR), improving source control and collaboration. Exi...
Diagnosing Power BI DirectQuery Performance Problems Caused By SQL Queries That Return Large Resultsets
One very common cause of Power BI performance problems is having a table with a large number of rows on your report. It’s a problem I wr...
What happened in DAX in 2025
Diagnosing Power BI DirectQuery Connection Limit Problems With Performance Analyzer
To kick off my series on diagnosing Power BI performance problems with Performance Analyzer in the browser (which I introduced last week with ...