Business Intelligence, Data Warehouse and Data Lake, Fast Focus

SQT04 Fast Focus: Datamarts in Power BI


1:30pm - 1:50pm

Level: Intermediate

Andrew Brust

Founder and CEO

Blue Badge Insights

In May, 2022, Microsoft announced the public preview of a new feature that lets you create datamarts, right in Power BI, without code, and with no ETL pipeline authoring required. As it turns out, these datamarts live in special instances of Azure SQL Database, and Power Query technology is used to load them. While everything may be automated, learning what gets built for you and how to manage it proactively is in your interest. So come to this Fast Focus session to see how the feature works, what assets it creates and how you can work with them, both passively and actively.

You will learn:

  • How to create a datamart in Power BI
  • How datamarts work in the background
  • How to access datamarts with tools like Azure Data Studio and SSMS
  • Considerations for upsizing to a Synapse Analytics data warehouse