🇬🇧 What's new in DAX

Join us on a journey through the DAX jungle led by the Product Manager in the Power BI team to discover what is new to make DAX easier to use for new explorers and more powerful for experienced discoverers!

Visual Calculations your DAX friendly interface and calculations

When we star working with DAX someone will always tell you that DAX is simple but is not easy. When you start making your business logic inside your semantic model you get lost with filter context, row context, the use of calculate and other concepts that overwhelm you.
In this session we are going to find out how can we have an easier approach to all our calculations, and use an Excel based approach using the Power BI's visual calculations.
We will do a live demonstration of how this feature can take your reporting calculation needs to a much more user-friendly approach when we talk about DAX.
To show off the practical and easy steps to a solid and efficient business logic, we will show case some practical scenarios like adding index columns for ordering, calculating cumulative sums based on visual selections and building a Pareto charts on the fly, all of this without the need to have different calculations for different sorting needs.
Off course this is not a perfect approach, we will also learn the limitations and common issues that we may encounter while implementing visual calculations.
In the end of this session, you will be able to understand the best use cases for the use of visual calculations and make DAX easy and simple.

Understanding the Inner Workings of Power BI Visual Calculations

Power BI Visual Calculations have been around for a while, and even though the feature hasn’t reached general availability, its use cases are expanding rapidly. Visual Calculations let you define calculations directly at the visual level, reducing the need for complex DAX and enabling faster insight creation.

In this session, we will discuss concepts like:
- How Visual Calculations differ from other calculation options in Power BI
- Visual Calculation–exclusive functions
- Navigating the lattice of the visual matrix
- Example use cases

Bringing your visuals to the next level by leveraging Visual Calculations

Join us for a deep dive into the inner workings of Visual Calculations and learn how to make your Power BI reports more dynamic, powerful, and easier to maintain.

Understanding the Inner Workings of Power BI Visual Calculations

Power BI Visual Calculations have been around for a while, and even though the feature hasn’t reached general availability, its use cases are expanding rapidly. Visual Calculations let you define calculations directly at the visual level, reducing the need for complex DAX and enabling faster insight creation.

In this session, we will discuss concepts like:
- How Visual Calculations differ from other calculation options in Power BI
- Visual Calculation–exclusive functions
- Navigating the lattice of the visual matrix
- Example use cases

Bringing your visuals to the next level by leveraging Visual Calculations

Join us for a deep dive into the inner workings of Visual Calculations and learn how to make your Power BI reports more dynamic, powerful, and easier to maintain.

Semantic Showdown: Tabular Editor vs. Semantic Link (Labs)

In the ever-evolving landscape of semantic model development and management, choosing the right tools can make all the difference.
In this session, we pit two powerful contenders against each other in a head-to-head comparison. Join us as we explore the strengths, capabilities, and unique features of each tool, showcasing how they approach semantic model creation, optimization, and maintenance. Through live demos, hands-on examples, and real-world scenarios, you'll gain insights into their advantages, limitations, and best use cases.
This session will help you determine which tool aligns better with your needs and goals. Let the showdown begin!

Power BI Report Design Workshop

Join us for an engaging Power BI Report Design Workshop led by members of the Power BI product team, Miguel Myers and Jeroen ter Heerdt. In this session, they will provide a comprehensive overview of the latest features and demonstrate how to leverage them to enhance your Power BI reports. Staying current with the frequent updates from Fabric can be challenging, but this workshop aims to inspire report creators by showcasing innovative ideas and methods for integrating new features into their work.

Participants will enjoy a refreshing and hands-on experience, learning to apply design principles and analytic enhancements effectively. The workshop will focus on utilizing the latest advancements to achieve your business goals and exceed expectations. Don’t miss this opportunity to elevate your Power BI reporting skills and stay ahead of the curve.

New in DAX: User Defined Functions, Calendars and more

Join us on a journey through the DAX jungle led by the Product Manager in the Power BI team to discover what is new to make DAX easier to use for new explorers and more powerful for experienced discoverers!

Harnessing the power of DAX for common analytical scenarios

**this content description is NDA and should NOT be posted online until the 1st of February**

DAX is a cornerstone of Power BI. As the capabilities of DAX continue to evolve, staying updated is crucial for maximizing its potential. In this session, we will explore the latest advancements in DAX and their practical applications for business calculations, enhancing code reusability, and conducting time-based analyses. Additionally, gain an exclusive preview of upcoming features that will redefine how you approach analytical queries. Join us to discover how these innovations can help you harness the full power of DAX and elevate your data analytics expertise.

A Report Developer / Data Analyst's Guide to Microsoft Fabric

Power BI, Dataflows, Semantic Models, Copilot & more!

Immerse yourself in the intricacies of Microsoft Fabric with a specialized training day tailored entirely to Data Analysts. While Thursday, February 6th, offered a glimpse into various Fabric topics, our upcoming training day on Friday, February 7th is your opportunity to delve deeper into the platform.

Your trainers are experts, who have been working in the subject area for years, and who will guide you through unlocking the full potential of Fabric through the lens of a Data Analyst. They will focus on the practical aspects, based on their experience of collaborating with customers worldwide.

We will cover core topics, including:

Power BI in the expanded universe of Fabric: Now Fabric is built on the foundation of the Power BI Service, as we know and love for years, what does Fabric bring to the table? What additional features and possibilities are useful to start exploring in the perspective of a Data Analyst.

Dataflows: As part of Fabric, Dataflows gen2 are available. What are dataflows gen2 exactly and how do they differ from dataflows gen1? Understanding data destinations of dataflows, the format in which the data is saved and staging of dataflow results.

OneLake and Lakehouse: Fabric centers around the lake and thrives on Delta. Further explore what lakehouses are and how they can be used by the Data Analyst.

Building Semantic Models in Fabric: Mastering the art of constructing robust semantic models tailored to your data analysis needs, including the new Power BI Direct Lake mode, how this storage mode compares to existing ones like Direct Query and Import.

Notebooks: A new concept for many and may look scary at first. Using Python and other coding languages is not something you do in your everyday life as Data Analyst. Explore how Notebooks can be used for semantic model analysis, optimization and documentation using Fabric Semantic Link in Notebooks.

Copilot for Microsoft Fabric: What is the fuzz everyone is talking about, in which places do we find copilot in Power BI and how can it help us be more productive?

Data Activator: Drive actions based on your data. No longer check conditions based on a fixed time schedule, but let’s turn it around and let the data trigger the action for you!

Visual Calculations: Making DAX easier

This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature!

Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.

Visual Calculations: Making DAX easier

This is it. The day that the way that DAX became easier. After this, how you write DAX changes forever. Learn all about it in this session! The Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting new feature!

Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.

Power BI Unplugged (EN)

Visual Calculations: Making DAX easier

Visual calculations, the biggest innovation in DAX ever, has been in preview since February. Visual calculations revolutionize how you write DAX, making it possible to put together calculations that were previously prohibitively hard to write. Come join this session to learn all about the feature from the product team itself. In this demo-rich session, we will talk about the feature, how to use it, what's new and what's coming soon! We will also cover the things you need to know so you can be successful in using visual calculations. Come see it for yourself. See the future, today.

Power BI Unplugged (EN)

Modeling with Power BI Product Team

Come meet the Power BI product team to talk about modeling

Power BI Custom connectors

Power BI heeft een hele hoop verbindingen beschikbaar, maar niet naar de hele wereld. Een van de mooiste uitbreidingsmogelijkheden van Power BI Desktop is de mogelijkheid om custom connectors toe te voegen, zodat je wel kunt verbinden naar dat ene lastige systeem. In deze sessie laten we je zien hoe je dat doet!

Modeling in Power BI – the key to success

Come learn about modeling, including what’s new and exciting from the Power BI team that focuses on modeling. We will cover the basics of modeling and why you should care as well as show new features and demos. If you want to be successful using Power BI, you will want to join this session.

Level-up your Power BI data modeling skills (EN)

After a successful webinar series on Data Modeling with Power BI, Jeroen ter Heerdt (Program Manager in the Power BI team at Microsoft) and Marc Lelijveld (Data & Analytics solution architect & Most Valuable Professional) will bring all their best practices on Data Modeling with Power BI together in a full day precon. We will split the day in three sections, where we kick-off with the basics of data modeling. Then we continue with more advanced patterns to finish the day with expert level modeling by using all advanced features and techniques.

So, what is a good data model in Power BI? How do you make sure you have the basics in place so the model you build today, will still work next year? We talk about different modeling concepts, whether to use the data model or Power Query for transformations, the differences in calculated columns and DAX with their effects on your model and handling role-playing dimensions.

After the basics, it is time to level-up by considering more complex patterns like different types of relationships, overcoming ambiguity, and successfully implementing aggregations. Also, different types of storages modes come into play. Dealing with DirectQuery and Imported (cached) data in the same model on table level with user defined aggregations, but also hybrid tables with different storage modes in the same table. Of course, we will talk about composite models with Power BI datasets and/or (Azure) Analysis Services.

To top-off this day full of real-life examples, we will talk about calculation groups and their behavior in composite models. We make sure you finish the day with a list full of tips and tricks that can be directly brought to practice directly.

After this precon you will be able to:
- Explain basic dimensional modeling concepts
- Create a well working and performing data model in Power BI
- Decide when to use Power Query vs the data model
- Decide when to use Calculated columns or measures
- Handle complex situations with inactive relationships and role-playing dimensions.
- Leverage one and bi-directional relationships
- Overcome and handle ambiguous data models
- Successfully implement aggregations
- Work with real live scenarios containing multiple fact tables
- Understand and explain different types of storage modes in Power BI
- Combine DirectQuery and import storage modes in a composite model
- Successfully implement calculation groups
- Understand calculation groups in composite models and their behavior

Keynote

Power BI empowers individuals, teams and organizations to drive a data culture and meet the most demanding enterprise needs. In this session you will hear about the Power BI strategy, learn where we’re heading, and see some fun demos of the latest features. Get inspired to drive your next innovation!

Improvements to doing calculations in Power BI

For the last 1.5 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting development for the first time ever, so you have not seen or heard about this anywhere else! This is brand new and exciting! Join this session to learn more about this new feature which will writing DAX statements so much easier and faster and get ready to get your mind blown!

Improvements to doing calculations in Power BI

For the last 2 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first). Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting development!

Join this session to learn more about this new feature which will make writing DAX statements so much easier and faster. Get ready to get your mind blown! See the future, today.

Improvements to doing calculations in Power BI

For the last 2 years, the Power BI team has been working on exciting things related to DAX calculations, specifically targeted at making it easier to add typical business-type calculations (such as running totals or vs-first).
Would you believe it if we told you that you don’t even have to type DAX anymore and still be able to get complex calculations done quickly? In this session, we will talk about this exciting development. This is brand new and exciting!

Join this session to learn more about this new feature which will writing DAX statements so much easier and faster and get ready to get your mind blown!

DirectQuery for Power BI Datasets and Azure Analysis Services

In Nov 2018, we released composite models, which allow you to seamlessly add multiple DirectQuery sources and imported data to your models. We have heard your feedback that you would like to do this with sources you previously live connected to, like Power BI datasets and Azure Analysis Services sources.
In December, we started previewing DirectQuery for Power BI datasets and Azure Analysis Services. This long-awaited addition allows report authors to use DirectQuery to connect to Azure Analysis Services or Power BI Datasets and, if they want to, combine it other DirectQuery and imported data.
In this session we will discuss this important feature and what it means to you as a user and to your organization.

Deploying Apps in SQL Server 2019 Big Data Clusters

Deploy your Data Science work onto SQL Server 2019 Big Data Clusters in minutes and turn them into REST APIs. Impossible? Think again. You deploy any R, Python or Spark model or even a SSIS package onto SQL Server Big Data clusters in seconds.

Data Modeling and DAX with Power BI product team

This is your opportunity to ask your questions to the Power BI team product managers working on data modeling and DAX directly!

Data modeling for experts with Power BI

Have you been working with Power BI for a while? Then it is time to take the next step with your data modeling skills!

You might have heard about Power BI composite models. But in order to implement them successfully, it is important to understand the different storage modes that Power BI has. This is key for a successful implementation and also understand the possible dangers of the storage mode behaviors.

More over, let's also talk Calculation groups! You might have been creating numerous calculations in the past for year to date, quarter to date and many other common patterns. With Calculation Groups you can limit the number of redundant measures by creating a common expression parts in a group, that can be applied on top of multiple measures.

And finally, we will combine the two together. Dealing with calculation groups in composite models. Cause there are some key-elements you have to keep in mind. Potentially this combination can lead to wrong results, if you do not understand the behavior of the remote and local engine and with that dealing with wholesale and non-wholesale queries.

During this demo-rich session I will take you on a tour through all above mentioned features and cases, and explain them one by one. So that after this session you will be able to;
- Understand and explain different types of storage modes in Power BI
- Combine DirectQuery and import storage modes in a composite model
- Successfully implement calculation groups
- Understand calculation groups in composite models and their behavior

BI Power Hour

The origins of the BI Power Hour are lost in the mists of time. According to legend, this demo-filled session was born when the Microsoft product team realized their amazing tools could not be constrained by Marketing-approved conference sessions.

For more than a decade, the BI Power Hour has delighted and amused audiences around the world, while adamantly refusing to teach those audiences anything useful in the real world. In this demo-filled session, members of the Power BI team are joined by select MVPs to show your favorite BI tool used for purposes for which they were never intended.

We can't guarantee that you'll laugh, but we CAN guarantee that WE will laugh - and we can guarantee that you won't learn anything that you can use when you get back to work. If you've never experienced the BI Power Hour, be sure to come early and get a seat.

If you're a BI Power Hour veteran, you're probably already in line.

Data modeling 101: Understanding the basics of a good data model

What is a good data model in Power BI? How do you make sure you have the basics in place so the model you build today, will still work next year? During this session we will lift of from basic level and build up in complexity to understand the key element of a good data model! Everything presented in this session will include real-life examples and can be directly brought to practice.

After this session you will be able to:
- Explain basic dimensional modeling concepts
- Create a well working and performing data model in Power BI
- Decide when to use Power Query vs the data model
- Decide when to use Calculated columns or measures
- Handle complex situations with inactive relationships and role-playing dimensions.

Best Practices for Composite models on Power BI datasets and Analysis Services (EN)

Best practices for composite models on Power BI Datasets and Azure Analysis Services

The preview of composite models on Power BI Datasets and Azure Analysis Services leveraging DirectQuery launched in December 2020.
We have seen loads of great use cases but also some challenges. In this session, we will cover best practices for this feature so you can get the best results.

AI & Visual Wizardry: Power BI's Dual Path to Insight

"AI & Visual Wizardry: Power BI's Dual Path to Insight" is a session aimed at demystifying the process of data analysis and visualization using Power BI for a wide audience, including both developers and end-users. It provides a thorough exploration of Power BI's capabilities, focusing on how its advanced features can be utilized to navigate the complexities of data.

For developers, the session will cover the use of Power BI’s AI functionalities and visual calculations to create sophisticated, intelligent dashboards and reports. Key topics include generating DAX queries with ease, enhancing reports with AI-driven visuals, and utilizing visual calculations for dynamic reporting.

On the other hand, end-users will learn how to leverage Power BI’s intuitive tools to independently explore and extend their data analysis, with a focus on using the 'Explore' feature for creating ad-hoc analysis and employing natural language queries for interactive data insights.

This session is designed to empower participants from various backgrounds to confidently use Power BI, making data-driven decision-making more accessible and insightful for everyone involved.

Advanced data modeling with Power BI

Got the basics in place and building a decent well performing data model in Power BI is a piece of cake for you? Time to take the next step!
During this session we will build up complexity and start integrating more advanced patterns in Power BI data models, covering topics like working with aggregations, composite models and more!

After this you will be able to:
- Leverage one and bi-directional relationships
- Overcome and handle ambiguous data models
- Successfully implement aggregations
- Work with real live scenarios containing multiple fact tables