You can experience the following sessions. Delivered by international experts from both Microsoft and the field.
-
20 Power Query (M)agic Tips That Every User Should Know
Self-service developers often have excel-files, SharePoint lists, Access databases, connecting to SQL database tables or views that IT maintains, multiple files, repetitive and manual tasks. Furthermore, self-service developers aren’t skilled in writing T-SQL or Python – we need another easier solution based on our competence levels and Power Query is defintely that tool!
This session will guide you through 20 tips and tricks on how to leverage Power Query and the (M)agic through UI, hidden gems and code to boost your use and understanding of Power Query.
Look forward to understand the difference between Power Query, Dataflows in Power BI and Fabric.
Whether you’re just starting or looking for that one extra trick to optimize your workflow, this session covers it all. -
Accelerate Insights to Action in Power BI
Join us for an exciting session on Translytical task flows in Fabric, a brand-new evolution in Power BI reports that enables automated action for seamless insights to actions. With Translytical task flows, you can automate end-user actions such as updating records, adding annotations, or even creating powerful workflows that trigger actions in other systems. Don’t miss this opportunity to learn about Translytical task flows and see tons of practical examples that elevate your reporting and streamline decision making!
-
AI + BI = CI (Combined Intelligence)
Many Power BI consultants today aren’t fully utilizing the wealth of (often free) AI tools available to make their workflows more efficient.
Despite the rapid growth of AI technologies, these powerful solutions remain underused, leaving significant opportunities on the table.
This session is designed to Open some Eyes about how OpenAI’s technologies can revolutionize the way you work with Power BI, driving efficiency and smarter decision-making.
In just one hour, we’ll explore 10 real-life use cases:
– Prepare dashboard sessions
– Determine Dashboard KPI’s
– Create dummy data.
– Generate, review and comment DAX and M code.
– Review and improve your datamodel
– Visual reviews and improvement of your dashboard
– Validate your dashboards on consistency, using only a screenshot!
– Create your own mini AI agents
– Using Open AI within Power Query
– And using this all… as learning solution in both text and voice
This session is tailored for Power BI professionals aiming to:
– Enhance efficiency
– Automate repetitive tasks
– Make smarter decisions with AI
Discover how integrating these tools can make your processes smoother, faster, and more effective.
Don’t miss this chance to gain actionable insights into using AI to transform your Power BI consulting—making your work not only easier but much smarter. -
Ambush Assassins: Secret killers of your Power BI performance and how to deal with them
Tired of slow performing Power BI solutions? Sick of user complaints that their report takes forever to render?
If you answered “YES” to either one of the questions above, join us for this session packed with best practices and tips to avoid secret (and non-secret) killers of the Power BI performance! No slides, no long story – it’s just YOU, Power BI, and us!
In this session we will reveal the most usual performance “assassins” of your Power BI reports, all the way from data loading, through avoiding non-optimal DAX code, and understanding visuals’ rendering time. After this hands-on session, you’ll walk away with a better understanding of the most common pitfalls in Power BI performance, and how to avoid them! -
Automate Your Power BI and Fabric Backups with Fabric Archive Bot
Join James Bartlett for a session where he introduces Fabric Archive Bot, a free and open-source tool designed to automate backups of your Power BI and Fabric workspaces. This session will cover the key concepts behind Fabric Archive Bot, including REST APIs, JSON, and Service Principal Authentication. James will also demonstrate how to set up Fabric Archive Bot, run it manually, and schedule automatic backups using Windows Task Scheduler. By the end of this session, you’ll have the knowledge to ensure that your Fabric items are securely backed up with minimal effort.
People who attend this session will:
– Understand the basics of how Fabric Archive Bot works, utilizing the Fabric REST APIs to enumerate and backup items from Fabric workspaces.
– See how using Service Principal Authentication (instead of User Principal Authentication) allows for 100% unattended automation of processes that would otherwise require a user to login.
– Learn how to set up and configure Fabric Archive Bot using the Azure Portal, PowerShell, and Windows Task Scheduler. -
Beyond the Basics: Deep Dive into JSON Themes in Power BI
You don’t have to choose between manual formatting and fully custom JSON—great themes happen when you combine the strengths of all three: Power BI’s built-in theme options, a theme generator, and direct JSON editing.
In this demo-driven session, we’ll walk through how to build and refine a Power BI theme efficiently by moving up and down the stack:
Start with Power BI’s theme UI to adjust basic settings
Export the theme and edit it in a generator to structure fonts, palettes, and visual defaults
Fine-tune in JSON to take control over unsupported or advanced properties
You’ll see how each tool leaves its trace, how to keep your file clean, and how to iterate quickly across tools—without losing your changes.
We’ll also briefly look ahead at early signs of theme variations—such as the ability to switch between multiple themes within the same report, or apply themes at a more granular level. These features aren’t widely available yet, but they hint at where Power BI theming may be headed.
This session is perfect for experienced report builders who want cleaner, faster, and more scalable design—without getting stuck in repetitive formatting. All examples will be shown live, no slides, with a downloadable file to take home and adapt. -
Calculation Groups & C#: Happily Ever After in Advanced Power BI
In the advanced session “Happily Ever After in Advanced Power BI,” we unravel the powerful alliance between Calculation Groups and C# scripting, a partnership that revolutionizes the creation and management of semantic models in Power BI. This workshop is designed to guide attendees through the process of harmonizing data model creation across their organization, providing a consistent, yet flexible foundation for Power BI users to build upon.
Dive into the heart of data modeling as we demonstrate how to leverage Calculation Groups alongside C# scripting to automate the standardization of semantic models. This approach not only ensures uniformity across all reports but also grants power users the agility to tackle complex reporting needs with ease and creativity.
Throughout this engaging session, we will meticulously craft a complete script from start to finish. This script will streamline the management of your semantic models by eliminating outdated measures, establishing vital Calculation Groups, and dynamically generating measures equipped with detailed descriptions and custom formatting. These steps are crucial in laying down a robust infrastructure that bolsters the efficiency and analytical capabilities of power users. -
Debug DAX like a PRO
Unlock the full potential of your Power BI models with our focused session on debugging and optimizing DAX (Data Analysis Expressions). DAX is a powerful tool for executing complex calculations, yet its performance can be hindered as models expand. This session is tailored to help you tackle these challenges head-on.
Discover optimization strategies that include refining data model designs with a star schema approach and optimizing DAX code. We’ll explore the use of variables to simplify calculations and offer alternatives to nested iterators for better efficiency.
Additionally, gain insights into using DAX Studio for in-depth query analysis, empowering you to refine and optimize your calculations. By the end of this session, you’ll be equipped with practical techniques to enhance your Power BI reports and accelerate data-driven insights.
Join us and master the art of DAX debugging and optimization, transforming data complexities into streamlined solutions. -
Enterprise Grade Semantic Models: the Certification Rules
Within our Microsoft MVP-owned consultancy, we have curated a certification ruleset for semantic models. This ruleset outlines the best practices that a semantic model must meet to achieve certification—a mark we reserve exclusively for expertly designed, enterprise-grade models.
This session will give you a chance to see behind the curtain as we openly walk through our semantic ruleset.
Learn essential best practices, optimization tips, security considerations, and practical advice for building robust semantic models.
The session will be fast-paced, covering tips across all aspects of tabular models. We’ll share our proven practices and certification checks in a session where you’ll undoubtedly pick up something new.
All attendees will also receive access to an exclusive blog, including links to foundational learning materials for those who want to dive deeper.
Attendees should have a good understanding of tabular models. Familiarity with tools such as DAX Studio, Tabular Editor, or working in TMDL view is encouraged. -
Exploring permission boundaries in Microsoft Fabric
Microsoft Fabric offers a wide range of options to define permissions for both item and data access, using different scopes of the platform. As options keep evolving, it’s a challenge to determine a viable permission strategy that works for the use cases at hand, offers business users the flexibility they are looking for, and passes those dreaded security checks to be able to move to production.
Focusing on a typical lakehouse architecture for data analysis using Microsoft Fabric, we’ll explore the different options that exist to provide access to items and define data security rules. We’ll discuss how these different options can impact business users, walking through pros and cons, and providing examples that are manageable and usable at scale. Above all, the guiding principle of least privileged access is our north star, making sure we do our part to keep company data safe.
We’ll tie personas and use cases to common data access patterns and assess how Microsoft Fabric can help us get the data closer to where the business user is, helping them to make better informed decisions using validated data.
After wrapping up the walkthrough, people should feel informed about the different options that exist, empowered to make their own decisions based on their own use cases and requirements, and reassured that it really isn’t that complicated as it seems. -
Power BI Azure Map. Are you Map Developer?
How often do you come across marketing and analytical materials that do not contain a map? Rather rarely. So what do maps give us? How do they increase the readability of data? I guess there is no need to provide an answer here.
So why does this topic not seem popular? In my opinion, it results from the Developer being overwhelmed. The Power BI Developer. Because when they learn the secrets of the database basics, then acquire knowledge of the M language, add data modeling, the use of computational techniques in DAX, the limitations and possibilities of native visualizations and visualization options from other providers, it seems that they already know everything.
However, when the need for data security, RLS, an application combined with domain access arises, the free mind resources begin to run out.
And then an idea appears – let’s add a map. The beginnings are promising, the national level, sometimes according to national capitals, can be implemented. However, when more advanced requirements appear, then basic geolocation is no longer enough.
It is necessary to use tools from outside the known environment. And then very often, expanding knowledge from completely unknown technology.
During this session, you will learn where to get data to increase presentation capabilities on maps. For this purpose, we will look into the QGIS environment to see how we can use this type of data in Power BI. We will also see what technical and substantive problems we can encounter while working with map data. I cordially invite you to travel with a map, but not with your finger on the map, but with a mouse cursor. -
Power BI Report Development with PBIR
The release of the Enhanced Report Format (PBIR) has been revolutionary for Power BI developers. Alongside TMDL, PBIR introduces a new era for Power BI source control, collaboration and automation.
And yet, very little is in the public domain about the power of the PBIR format. This session provides a much-needed introduction to the new capabilities.
Report scripting? Co-authoring? Code-based change reviews? Just some examples of what is now possible.
You will learn about the new folder structure and file formats, what it means for your development workflows, and which tools individual report developers as well as teams should be aware of. -
Power BI Tables and Matrix Visuals: The Next Step
Let’s face it: Many Power BI reports include at least one table or matrix visual, and that’s not necessarily a bad thing. While they are familiar, flexible, and likely the easiest way for report creators to display detailed data, they often represent a lack of trust in the data, which leads to the wish to see all the details. This means they’re just Excel tables in disguise: packed with data but doing little to support decision-making.
This session is about taking tables and matrix visuals to the next step. We will look at transforming these visuals into something that works with your users rather than against them. Think cleaner layouts, smarter use of space, and formatting that highlights what matters without needing to scroll through hundreds of rows. You will see examples of how to upgrade a basic table or matrix visual into something that adds value for the end user and at the same time increases trust in the report data itself. From subtle design tweaks to DAX tricks for dynamic elements, this session aims to provide you with ideas you can implement right away.
We will also address typical challenges, such as how to respond when the end-user requests “just the raw data” or “a copy of my Excel report in Power BI” and determining when it may be more effective to skip the matrix entirely.
What we’ll cover:
• Conditional formatting that adds meaning, not just color.
• Layout tricks to reduce clutter and improve usability.
• DAX techniques for showing the right context at the right time.
• How to avoid endless scrolling (and what to do instead)?
• When not to use a table or matrix and what are the better options?
This session is intended for report creators ready to move beyond basic matrix and table visuals and create visuals that improve clarity, user engagement, and action.
Key Learning Objectives:
• Learn to use formatting, layout, and DAX to support better decisions.
• Discover small tweaks that make a big difference in usability.
• Walk away with practical ideas you can apply in your next report. -
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! -
Taking your visual further with Visual Calculations
DAX is simple but not easy – but Visual Calculations is both simple and easy, and can help your visualizations in Power BI if you know about how they work and when you should use them and when not to use them.
In this session I will take you through the basics and then quickly move on to the more advanced functions that will enable you to understand how the functions EXPAND, COLLAPSE, RANK, INDEX and more can be used to make your DAX at the visual level simpler.
The visual calculations can also be used in conditional formatting to make your visuals dynamic and perhaps limit the need for visual specific measures in your datamodel.
We will do this through all lot of demos that should inspire you to use them in your own reports. -
Tales from the Trenches: Lessons from Big Power BI Projects
From our experience managing hundreds of small, medium and massive Power BI projects at 3Cloud, I will showcase:
– Successful design patterns that always work
– Silly things that clients want to do
– Lessons learned from mistakes in the past
– Planning for the future and improving successful outcomes
I will walk you through five different projects for enterprise consulting clients, from requirements to solutions. We will discuss the challenges and hurdles that we overcame to solve difficult problems, related to technology and people/process and communication. -
The Ultimate Power BI Productivity Boost with TMDL and Fabric Studio
Ready to Revolutionize Your Power BI Development?
Imagine being able to copy entire tables and measures in bulk from one semantic model to another—instantly. What if you could rename measures in bulk, or use a simple find and replace to update logic across all your DAX measures at once? How about creating perspectives or implementing object-level security directly within Power BI Desktop? And the best part? You can publish new DAX measures, add new tables, or modify existing DAX measures and tables without having to re-publish the entire PBIX file.
Sounds like a dream? It’s all possible with TMDL (Tabular Model Definition Language). TMDL is the game-changing Power BI feature we’ve been waiting for. The much-anticipated Power BI “developer mode” is here and ready to supercharge your Power BI development experience. And with Fabric Studio, it’s like magic.
In this session, real-world examples will teach you how TMDL can make your Power BI tasks easier. We’ll show you how to leverage TMDL and Fabric Studio and build your skills to take full advantage of this powerful new feature. -
Under the Hood: How Power BI Modeling Tools Really Work and What Comes Next
Curious about what really happens under the hood when you build models in Power BI Desktop — and how to get the best performance from your modeling experience?
Join a Power BI Product Manager and Engineer as they take you on an inside look at the powerful engine behind Power BI Desktop.
In this session, we’ll reveal the sophisticated inner workings that make modeling possible across all Power BI personas, share expert tips and lesser-known best practices to help you work smarter and faster, and give you a sneak peek into the exciting improvements we’re making to take modelling performance to the next level!
PS – This session won’t cover traditional semantic modeling best practices like DAX tips or star-schema design. Instead, you’ll gain a deeper understanding of how Power BI tools work—so you can better apply that knowledge to your advantage.
