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
Data Validation In Power BI Copilot AI Instructions
Here’s yet another post in my series on things I think you should be doing in Power BI Copilot AI Instructions. Today: validating values...
Building Translytical Flows in Power BI Reports
Microsoft has introduced Translytical Task Flows (Preview) in Power BI — a groundbreaking capability that brings transactional actions directl...
What Fields to Hide in Your Power BI Solution?
To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple...
Celebrate with us as Power BI Turns 10!
Power BI is turning 10, and we’re celebrating a decade of turning data into insight and impact. From 500,000 early adopters to over 375,000 or...
Power BI Copilot AI Instructions: Helping Users Understand The Scope Of The Data
Continuing my series of posts on Power BI Copilot and the type of things you should be including in AI Instructions, today I want to talk abou...
Power BI UX Just Got Easier
Limit on number of users or groups that can be added to workspace roles in Fabric and Power BI
Microsoft Fabric will limit workspace roles to 1,000 users or groups from August 1 to August 31, 2025. Overlimit workspaces can’t add more use...