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