(Livestream Replay) DAX Query View Testing Patterns - with John Kerski

DESCRIPTION 📄

Are you struggling with managing issues in your semantic models/datasets? Would you like to conduct tests and easily share those tests with your team? In this session I show you a DAX Query View Testing Pattern. This pattern combines the new DAX Query View feature in Power BI Desktop and DataOps principles to help you improve project delivery and reduce errors.

GUEST BIO 👤

John leverages his 10+ years of technical and government leadership experience to help Federal Agencies, and private sector clients utilize Microsoft products to their fullest potential. His certifications with Microsoft products offers customers a high rate of return when looking to invest in Microsoft solutions.

RELATED CONTENT 🔗

Blog
LinkedIn

(Livestream Replay) Practical Use Cases for DAX Calculated Columns - Tristan Malherbe

DESCRIPTION 📄

Over the last few years, many debates arose in the Power BI community about the use of DAX Calculated Columns. In this session, Tristan Malherbe will show concrete & real-life use cases to illustrate the power of DAX Calculated Columns. The main topics covered will be:

• Context Evaluation (Filter context, Row Context, Context Transition)

• Static Segmentation based on DAX measures
  Pre-Computing flags in Dimension tables to boost your Power BI reports' performance and ease your DAX calculations

• Inter-table calculations

• Inter-row calculations and windowing patterns with the new DAX windowing functions

GUEST BIO (Triastan Malherbe)👤

Tristan Malherbe is a Microsoft Data Platform MVP since 2017. He is the creator and current co-leader of the French Power BI User Group (Club Power BI, 7,000+ members) and more recently the French Fabric User Group (Club Fabric, 300+ members). Over the last 7 years, Tristan gave 150+ Power BI conferences & trainings in America, Europe and Middle-East. His favorite topics are Data Architecture, Data Modelling/DAX & performance tuning. Tristan is also the co-founder of Data Pulse, a Fabric & Power BI consulting firm (14 people) based in France.

RELATED CONTENT 🔗

PBIX Link
Twitter
LinkedIn
YouTube
MVP Profile

(Livestream Replay) The Cost of a Workaround in Power BI - with Injae Park

DESCRIPTION 📄

From using SVGs or DENEB to create unique visuals, to page level security with RLS - workarounds are often necessary to overcome limitations and achieve desired functionalities in Power BI. However, these workarounds come with their own set of costs and considerations. This session discusses the key factors to help developers evaluate workarounds in Power BI, ensuring that the benefits outweigh the potential drawbacks.

To do this, we will explore some real-life workarounds in Power BI such as code-based Custom Visuals (DENEB, SVGs, HTML, Python), Page level security, and storing a custom PowerQuery library in Github. We will also dive into the trade-offs involved, including maintainability, impact on development, and technical debt.

GUEST BIO 👤

Injae Park is a Microsoft Data Platform MVP who combines his technical expertise with a passion for teaching by sharing his insights and practical tips through his YouTube channel @PowerBIPark. Injae's content ranges from beginner tutorials to advanced techniques, and as part of the Power BI Core Visual Representatives - he aims to bridge the MS Developer team with the Power BI community. His education in psychology and economics as well as his experience in consulting gives him a well-rounded perspective on the Power BI Developer experience, making his tutorials both engaging and accessible.

RELATED CONTENT 🔗

Injae’s Linkedin
Injae’s Youtube
Injae’s Github

(Livestream Replay) Fabric & Power BI: Awesome Use-Cases with DAX Query View - with Zoe Douglas

DESCRIPTION 📄

Join us live as we dive into the world of Microsoft Fabric! In this session, Zoe will walk you through the process of creating semantic models using three powerful approaches: Direct Lake, Import, and DirectQuery (DQ). We'll explore how each of these methods can be utilized within Microsoft Fabric to build robust and scalable models tailored to your data needs.

But that's not all—once we've crafted these models, I'll demonstrate how you can leverage them to write efficient DAX queries using the DAX Query View. Whether you're new to Microsoft Fabric or looking to refine your skills, this demo will provide valuable insights and practical techniques you can apply to your projects.

Bring your questions and curiosity, and let's explore the possibilities together!

GUEST BIO (Zoey Douglas)👤

Zoe is a Product Manager at Microsoft working on Power BI in Microsoft Fabric with features such as DAX query view, Direct Lake, Model Explorer, and Copilot. Before coming to Microsoft I was a Power BI consultant and mentor, enjoying the Power BI community forum and taking on data challenges.

RELATED CONTENT 🔗

Direct Lake
DAX Query View
Web Modeling
Model Explorer