When designing visuals and reports, it’s extremely important to consider those who are not able to see the difference between certain colours. For those who are colour-blind, the ability to differentiate certain hues depends on the colour contrast ratio. Approximately 350 million people around the world experience some form of colour-blindness ( inability to see the difference between certain colours). Ideally, we should always try to use accessible colours when designing reports but often this is not possible due to existing branding guidelines and colour conventions like RAG (red, amber, green) used to report on performance and progress. The absence of easily accessible options for toggling between various themes and colour schemes in Power BI often results in reports that lack accessibility. In this session, we will explore the built-in accessibility features of Power BI and discuss WCAG guidelines for colour usage. I will also demonstrate how to choose accessible colours and share a practical solution I have previously implemented, which enables users to switch between standard and accessible views. This approach not only enhances flexibility but also ensures inclusivity for all users. Additionally, this initiative has significantly raised awareness about digital accessibility among both users and stakeholders. Optimising reports for people affected by vision impairment ensure equitable opportunities for all users. Taking diversity, inclusion and equity into account when designing visualisations and reports is a good way to express care and concern for all colleagues and stakeholders. It increases trust, collaboration and even innovation.

In this session, you will learn how Quorum used the Power Platform to create a virtual road trip across the continental United States to keep employees active and engaged during the pandemic. The team faced a difficult challenge: to create an engaging and interactive experience that could be shared with everyone in the company, regardless of their technical expertise. Using their extensive experience with UI design and data storytelling, the Marketing, Apps Dev, and Data Teams at Quorum produced an elegant and easy-to-use Power BI dashboard showing daily progress towards the goal. The data was distributed to Teams and SharePoint for anyone to see. Through the Power Platform, the team created interactive postcards as they crossed each state boundary on their USA road trip. In this session, you will learn: how to use the Power Platform to create engaging experiences, how to design user interfaces that are easy to use, how to tell stories with data using Power BI, how to use the Power Platform to share information and collaborate with others.

The new DAX feature we've all been waiting for is now available: user-defined functions! A function is a DAX formula with parameters that can return values or tables. Parameters can be passed by value or by expression. In this session, you learn how to define, consume, and share user-defined functions in your semantic model with Power BI. The session will cover: What are user-defined functions; How to create effective functions; Understanding how functions are executed.

Tired of slow Power BI reports? Master the VertiPaq engine and the art of query folding! This talk is packed with practical techniques to optimize your data models and queries. Transform your Power BI skills and build reports that impress.

Discussion des nouveautés Power BI annoncées à Fabric Conference Europe.

Autres outils, méthodes et bonnes pratiques pour garder vos projets Power BI clairs et compréhensibles

Démonstrations concrètes et retours d’expérience

Échanges interactifs avec les participants

Exploration de la vue TMDL pour une meilleure lisibilité et gestion des modèles

Tour de table des coorganisateurs sur leurs approches de documentation

Utilisation des fonctions DAX INFO.VIEW pour enrichir la documentation technique

Reitse deelt de nieuwste inzichten over Microsoft Fabric, waaronder updates over Power BI, OneLake, Data Factory, Real-Time Intelligence, en AI-integraties.

Slow performing Power BI reports and visuals are a major cause of frustration. Finding the cause of these slow-downs and understanding why they are happening are the first steps in resolving them.

In this session we'll discuss the troubleshooting steps for slow DAX executions, using tools like Performance Analyser and DAX Studio.

We'll cover the different purposes behind the two parts of the DAX engine - Storage and Formula, and how to write expressions that target each individual component, allowing us to utilise their combined power to unlock the full potential of DAX.

We'll see how optimising expressions in order to harness the power of these engines helps increase performance. This will be done using live demonstrations showing the actual difference in executions times as well as exploring query plans.

By the end of this session, you will know how to identify which DAX expressions are causing issues in your reports, you'll have a solid understanding of what the DAX engine consists of, how the parts work together and how to use them to your advantage to make your expressions faster and more efficient. You will also know how to view a DAX query plan to help troubleshoot slow performing queries.

Les Calculation Groups (groupes de calculs) sont disponibles depuis 2018. D'abord via Tabular Editor (outil externe gratuit) puis en natif dans Power BI Desktop en 2023. Ces groupes de calculs sont une arme redoutable pour améliorer votre code DAX et mieux le factoriser. Au cours de cette session, Tristan Malherbe vous montrera comment les utiliser pour répondre à des cas d'usages métiers fréquemment rencontrés: gestion des calculs temporels, modélisation des role-playing dimension, segmentation dynamique et reproduction du comportement de colonnes calculées DAX dynamiques.

Blast off into the future of analytics with this interstellar session on real-time data processing in Microsoft Fabric! From setting up KQL databases to capturing data streams from the International Space Station (yes, really!), this session is packed with hands-on tips and tricks. You'll explore how to harness the power of Event Streams and Logic Apps to create a seamless data pipeline that fuels real-time Power BI reports. Discover the basics of KQL—spoiler alert, it’s not SQL! Learn to query data like a tabular astronaut, watching your dashboards come to life with up-to-the-minute updates. With step-by-step guidance and plenty of cosmic creativity, you'll master real-time analytics faster than a rocket launch. Whether you're a data explorer, a real-time analytics enthusiast, or just curious about real-time tracking space missions, this session is your ticket to the stars. Prepare for liftoff as we explore how Microsoft Fabric can transform your streaming data into celestial insights.

Overview of Microsoft's Power Platform components (Power BI, Power Apps, Power Automate, Power Pages, and Dataverse) and how to design and create practical, low-code solutions using these integrated tools.

Slow performing Power BI reports and visuals are a major cause of frustration. Finding the cause of these slow-downs and understanding why they are happening are the first steps in resolving them. In this session we'll discuss the troubleshooting steps for slow DAX executions, using tools like Performance Analyser and DAX Studio. We'll cover the different purposes behind the two parts of the DAX engine - Storage and Formula, and how to write expressions that target each individual component, allowing us to utilise their combined power to unlock the full potential of DAX. We'll see how optimising expressions in order to harness the power of these engines helps increase performance. This will be done using live demonstrations showing the actual difference in executions times as well as exploring query plans. By the end of this session, you will know how to identify which DAX expressions are causing issues in your reports, you'll have a solid understanding of what the DAX engine consists of, how the parts work together and how to use them to your advantage to make your expressions faster and more efficient. You will also know how to view a DAX query plan to help troubleshoot slow performing queries.

A session on re-architecting data workflows to significantly optimize performance in Azure Data Factory. Insider’s look at different architectural designs and practical insights for faster, less complex data processing with Azure Data Factory.

Danny heads up the Birmingham City Observatory. He'll be showing us how to boost user engagement and adoption by embedding interactive tutorials directly into your Power BI reports. Learn how guided, built-in onboarding can turn first-time users into confident, engaged adopters while making your dashboards more impactful and user-friendly.

Présentation des nouveautés Power BI de l'été et récapitulatif de la saison, animée par Jean-Pierre Riehl, Tristan Malherbe et Guillaume Gaudfroy.