Loading...

Add Data at Scale | Datamart in Power BI

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
Microsoft Mechanics Podcast
Microsoft Mechanics Podcast

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.

Share post:

Related posts

Power BI May 2026 Feature Summary

Welcome to the May Power BI update!Power BI continues to evolve with updates that make it easier to explore data, generate insights, and build...

4 hours ago

Agentic AI in Power BI and Fabric, Part 3: Agentic AI in Action with GitHub Copilot and Power BI Modeling MCP

In the previous blog, I covered the practical setup for agentic AI workflows with VS Code, GitHub Copilot, and safe local MCP testing. I…...

19 hours ago

Power BI Semantic Model Memory Errors, Part 5: The “Maximum Allowable Memory Allocation” Error

This is a very late addition to the series of posts I wrote back in 2024 and which started here on Power BI memory errors. It’s about a ...

2 days ago

Unlocking deeper Copilot insights with enhanced Power BI filtering

Starting late May 2026, Viva Insights admins can enable reserved and custom attributes as filters in Power BI reports, allowing deeper, busine...

4 days ago

Execute DAX Queries REST API (Preview)

Author: Kay Unkroth - Principal Program Manager 

5 days ago

Common Mistakes When Sharing Power BI Reports from Workspace

Sharing a Power BI report sounds like it should be simple. You build the report, you publish it to a workspace, and then you give your end use...

6 days ago

Connecting Power BI Semantic Models To Data Sources Automatically With Binding Hints

Did you know that you can configure your Power BI semantic model so that it automatically binds to a data source connection when you publish? ...

9 days ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy