(Livestream Replay) Power BI Desktop "Developer Mode" and Fabric Git Integration - with Rui Romano

DESCRIPTION 📄

Microsoft Power BI Desktop developer mode brings Pro BI developer experiences right into Power BI Desktop and together with Git integration, you can enable seamless collaboration within your development team.

At this session you will learn on how to take advantage of these new tools and features to unblock professional Power BI development experiences within Microsoft Fabric, but also improve your development efficiency by leveraging programmatic generation and editing of content (in a fully supported manner).

GUEST BIO 👤

Rui is an experienced Microsoft Professional with a deep passion for data and analytics. He has spent the last decade helping companies make better data-driven decisions and is known for his innovative and practical solutions to complex problems.

As a speaker, Rui is engaging, insightful, and highly knowledgeable. He can distil complex data concepts into simple, understandable language, and is truly passionate about helping others develop their data skills.

Currently works as Product Manager at the Power BI product team, focusing on Pro-BI experiences.

RELATED CONTENT 🔗

Rui's Twitter
Rui's LinkedIn
Rui's Github
Developer Mode Guidance

(Livestream Replay) Introducing TMDL for Power BI! - with Mathias Thierbach

ABSTRACT 📄

An early look at the Tabular Model Definition Language (TMDL), soon to be released by Microsoft as a public preview as part of the Tabular Object Model (TOM) libraries. TMDL was first presented at SQLBits in March 2023 and is the first of several new innovations and tools targeting the needs of Power BI Pro Developers.

It consists of new declarative format for tabular models, designed for readability and editability, as well as a standardized folder structure for those files (similar to tabular Editor's "Save-to-folder" format), enabling collaborative workflows. Mathias has implemented TMDL as part of the Power BI Contributor Program. He will present the key aspects of the language as well as its main benefits.

GUEST BIO 👤

Mathias is a Data Platform MVP and Head of Finance Systems at YouGov in London. He cares deeply about mature enterprise-grade development and delivery patterns and practices for Power BI. To that end, he has developed pbi-tools, which was released as an open source tool in October 2021. Furthermore,

Mathias has presented his learnings and best practices around Power BI DataOps, CI/CD, and Deployment Automation, but also talks on the organizational and managerial aspects of running a successful Poewr BI team at several international conferences and many user groups.

RELATED CONTENT 🔗

Mathias's Twitter
Mathias's LinkedIn
PBI Tools

Normalized Rank Ribbon Size Chart in Power BI

Learn how to upgrade your ribbon charts to prioritize the rank between categories. We'll use a bit of DAX magic mixed with some Calculation Group wizardry to achieve this result in Power BI Desktop. Tune in to learn more!

Video by: Reid Havens

(Livestream Replay) Semantics of DAX Queries & Caveats to Composite Models - with Jeffrey Wang

The popularity of Power BI has increased dramatically in the past few years. I am seeing an increasing number of enterprise customers who built complex composite models combining import tables with DirectQuery tables. Many users have asked questions on how DAX queries and measures are translated into remote SQL/MDX/DAX queries. To the surprise of a lot of people who have a SQL background, the semantics of DAX queries is very different from that of SQL queries even though both are used to produce the right data for the same visualizations. I am going to explain why the semantics of DAX queries poses unique challenges to DAX engine and how the latter employs myriads of optimizations to deliver good query performance in common scenarios. I am also going to explain how the semantics of DAX queries complicates query generations for composite models, demonstrate some of the issues most frequently encountered by the composite model users, and describe design principles to avoid the pitfalls.

GUEST BIO 📄

Jeffrey joined Microsoft SQL Server Analysis Services team in 2004 and contributed to the revolutionary transformation of Microsoft BI from multi-dimensional model and MDX language to tabular model and DAX language. He was one of the inventors of the DAX programming language in 2009 and have been driving the evolution of the DAX language ever since. Currently he is an engineering manager focusing on the development of DAX engine, query optimizer, DirectQuery, composite models, etc. Right now his team is putting the finishing touches on the GA of DirectQuery to PowerBI datasets.

RELATED CONTENT 🔗

Website
Blog
Power Query's Twitter
Miguel's Twitter