Getting SAP Data into Microsoft Fabric: Migration Choices & Risk Mitigation

If you're pulling SAP data via Azure Data Factory, recent SAP licensing changes around change data capture make some ingestion approaches risky, like the ADF CDC connector. This Fabric-focused session explores supported alternatives.

In this session you will learn:
- Why traditional ADF + CDC approaches are problematic post-policy changes
- Fabric-native ingestion options: SAP Datasphere mirroring, Fabric Copy Jobs, and SAP Business Data Cloud Connect
- How to compare batch vs. incremental patterns for OneLake ingestion
- A decision framework to choose the right approach for your SAP landscape
- A phased transition plan to migrate existing pipelines

Best for: Data engineers and architects managing SAP - Fabric migrations.

How to use GraphQL with Fabric SQL Database

Learn how to expose your Fabric SQL Database through a GraphQL API to make data available externally. This session covers setup, schema generation, and query execution, showing how GraphQL can simplify data access. We’ll walk through authentication, and integration options for building a modern, data-driven app on Fabric.

After this session, participants will be able to:
* Set up a GraphQL endpoint on top of a Fabric SQL Database.
* Generate and understand GraphQL schemas for querying Fabric data.
* Apply authentication and integrate the API into real-world applications.

Live Q&A: Governance and Administration of the Power BI Service

During this interactive Q&A session you can ask all questions on administering and governing the Power BI Service. We will try to provide you with answers to all your questions, based on our experiences with our clients and the organizations we work for.

Over the last couple of years, we have learned that being a Power BI Service administrator is much more than just turning on or off the Power BI Admin settings (no matter how vital these settings are).

The focus of this Q&A is not only the Admin settings, as we Power BI admins are also impacting the data culture of an organization. We can discuss aspects of sharing data inside and across organizations. But we can also talk about what has to be done to meet the requirements of data governance and compliance rules requirements.

Direct Lake, Import, Direct Query – Mastering Semantic Model Storage Mode

In the world of semantic models, choosing the right storage mode is crucial. Whether you’re dealing with Direct Lake, Import, or Direct Query, each storage mode has distinct advantages and use cases.

We're diving into the different storage types that are available for your semantic models. Each of the Direct Lake, Import, and Direct Query modes has its own use case. When should you choose what? What should you consider when choosing a certain storage mode? Or even more exciting, a combination of storage modes?

We’ll delve into real-world scenarios where each storage mode shines. When should you opt for Direct Lake? How does Import mode excel in certain situations? And what about Direct Query? These questions we'll answer together.

Next to exploring the different storage modes we'll also dive into optimization strategies. Learn how to leverage aggregations effectively to boost the performance of your import models. Discover best practices for query folding in Direct Query mode. And unravel the mystery behind ‘framing’—a key concept for working in Direct Lake.

By the end of this session, you’ll be equipped with practical insights to confidently choose storage modes and optimize your semantic models.

Although anyone can benefit from this session, a basic understanding and some level of experience is assumed in the examples and demos. We won't be doing a 101 or introduction level things.

So You Are The Fabric Admin... Now What?!

Do you know your way around Power BI Desktop, but don't know what happens beyond it, or what has to be managed in the Service?
Do you have the privilege, as an IT Admin or Global Administrator, to "also take care of Fabric"?
Did you just receive the responsibility for some, or even all, Fabric Administrator tasks? And what about all the (new) Fabric workloads, like Spark compute?
Do you also not know what the Power Platform (management) really is?

If you answer Yes to any of the questions above, this session is for you!
Managing a Fabric capacity is not easy and involves many decisions. Now that Copilot can be used in every capacity, you also need to manage the dedicated Fabric Copilot capacity. And do you want to use Autobilling for Spark?

In this session, we will take a look at tasks and components that can (or should!) be part of a Fabric Admin's daily routine.
- The changed role of the Fabric Admin
- Tenant settings
- Capacity controls
- Power Platform Admin Center
- Monitoring options

I will also show a few examples of monitoring solutions, out-of-the-box as well as custom solutions.

When you start applying the tips and tricks of this session, you will get a grip on your Fabric tenant!

Making The Most Out of The Power Platform

Are you looking to empower your users with the ability to refresh the Power BI dataset directly from within a report? Do you need the capability to edit your data seamlessly in a Power BI report? Would you like to ensure that your Power BI dataset refreshes automatically as soon as the connected dataflow is updated?

Now you can achieve all this with the integration of Power BI, Power Apps, and Power Automate!

Join us in this live demo session, where we will explore how the Microsoft Power Platform products can work together to create dynamic, user-friendly, and interactive data solutions. I will demonstrate practical examples of how these tools can enhance your data management capabilities, streamline workflows, and provide a more responsive and interactive experience for your users.

Target audience:
Current users of Power BI who want to expand their capabilities by incorporating additional Microsoft Power Platform products.
Individuals who work with data analysis and business intelligence, looking for ways to optimize their reporting processes and enhance data interactivity.

Key Takeaways:
Integrated Data Solutions: Learn how Power BI, Power Apps, and Power Automate can be combined to create seamless and interactive data experiences.
Enhanced User Capabilities: Discover how to enable report users to refresh datasets and edit data directly within Power BI reports, providing greater control and flexibility.
Automated Workflows: Understand how to set up automated data refreshes that trigger as soon as connected dataflows are updated, ensuring your reports always display the most current data.
Practical Implementation: Gain insights into the practical steps and best practices for integrating these tools, demonstrated through live examples.

From Report to Action: Write-back with Translytical Task Flows

Power BI isn’t just for slicing and dicing anymore. With (new) integrations across Microsoft Fabric and Power Platform, you can now write data back, trigger custom logic with User Data Functions (UDF's), and build real-time, translytical apps, without ever leaving the report.

In this session, I’ll show you how to go beyond passive dashboards by combining:
* A Power App inside Power BI to write back to your database,
* UDF's in Fabric to run logic server-side, and
* The Power BI button action (using Translytical Task Flows) that triggers UDF's directly from your report.

We’ll build a simple end-to-end translytical solution: input, update, and recalculate - all from inside a Power BI report. Along the way, I’ll show real-world use cases where these features unlock new types of business apps.

This session is intermediate level: Power BI experience is expected. No prior experience with Power Apps or Fabric UDF's is required, we’ll build that up step by step.

Planning Your Move to Microsoft Fabric: What Migrates, What Breaks, and How AI Helps

Are you moving your Synapse Serverless or Azure SQL data platform with data pipelines to Microsoft Fabric?
Learn an assessment first approach that highlights what migrates cleanly and what needs redesign (think Mapping Dataflows).
We cover common blockers and show how AI can analyze pipelines, SQL, and metadata to score complexity, map dependencies, and build Fabric capacity cost scenarios.
We'll show how AI can automate the assessment, flag breaking changes, and predict capacity costs.

Agentic Power BI Development: From PBIP to Pair Programmer

Can you really let an AI agent work on a Power BI project, or will it confidently break something?

PBIP makes that question worth asking. Reports and semantic models live in files, which means tools like GitHub Copilot can read and edit them. Add the right project context, skills, and MCP connections, and Copilot can do more than answer questions: it can help with real development work.

In this session, we’ll show what that looks like in practice. We’ll use Copilot’s agent mode with PBIP to draft DAX in TMDL, document a model, make bulk edits, review a pull request, and connect to Power BI Desktop and Fabric through MCP.

But “the agent can do it” is not the same as “the agent should do it.” We’ll look at where this workflow saves time, what context makes a difference, and the kinds of confident mistakes you still need to catch.

You will leave with a realistic view of agent-assisted Power BI development and a workflow you can try in your own projects.

Prerequisites: basic Power BI development, PBIP/Git familiarity is helpful.

What Is Microsoft Fabric and How Does It Benefit You as a Power BI Developer

In this session we will introduce you to the possibilities that Microsoft Fabric brings for Power BI developers. For a Power BI developer starting with Fabric, it is important to understand that Fabric enables all components to be developed and managed in the Power BI platform as native assets. This means that you can use Fabric to unify your data estates and unlock value with a data integration experience that combines the ease of use of Power Query with the scale and power of Data Factory.
After this session you will understand the different capabilities like Direct Lake, Git Integration, and Dataflows Gen2. We will bring you up to speed with all the new features in Fabric that you need to know as a Power BI developer, combined with real world demo's.

Level 200, no prerequisites.

Power BI External Tools: What the Community Built

Have you ever wanted to see what is happening behind a slow Power BI report? Or wished there were a better way to compare model changes, clean up a semantic model, or make sense of your DAX?

Power BI Desktop is great, but it doesn’t do everything. Luckily, the community has built a whole set of tools to help with the parts that can be difficult, hidden, or repetitive. The tricky bit is knowing which tool is useful for which problem and whether it fits the way you work.

In this demo-heavy session, we’ll take a practical look at tools like DAX Studio, Tabular Editor, ALM Toolkit, and Measure Killer. I’ll show what each one is good at, where it fits into a Power BI workflow, and what to consider around cost, compatibility, and learning curve. You’ll see how they can help with DAX, model development, performance investigation, and comparing or cleaning up models.

You don’t need to have used these tools before. Bring your curiosity and a Power BI problem you’d like to solve. You’ll leave knowing how they can make everyday Power BI work a little easier.

I’m not affiliated with any of these tools, I just use and appreciate them in my day-to-day work.

I’m not affiliated with any of these tools, I just use and appreciate them in my day-to-day work.
Audience:
* Power BI report authors and analysts who want to go beyond Desktop’s built-in features
* Power BI developers who want to improve their model-development workflow

Optimizing Your Power BI Workflow with Project Files, Source Control, and TMDL

You're part of an analytics team at a fast-growing tech company, relying on Power BI for key insights. But as your data and team grow, so do the challenges: messy files, unclear version history, and unwieldy data models.

Then inspiration strikes - another team solved similar issues by adopting a structured project setup, using source control, and managing models with TMDL. You follow their lead.

Months later, your workflow is streamlined, collaboration is smooth, and your reports are sharper than ever. This session shares the strategies that made that transformation possible - so you can apply them in your own Power BI projects.

In this session, we will guide you through these strategies, demonstrating how to replicate this success in your own Power BI projects.
By the end of this session, you will be equipped with practical knowledge and tools to optimize their Power BI workflows, ensuring their data analytics projects are well-organized, versioned, and scalable.
We will start with a regular PBIX-file and gradually transform it into an organized, versioned model. Using Visual Studio Code, we will set up source control in Azure DevOps with the PBIP-format, apply TMDL and eventually integrate Git into the workspace.
Note: This session assumes a basic understanding of Power BI. Fundamentals of source control and branching will not be covered.

Key Takeaways:
Structured Project Management: Learn how to keep your Power BI project files well-organized.
Source Control: Discover how to use source control in Azure DevOps to track changes meticulously.
Efficient Data Modeling: Leverage TMDL to manage complex data models effectively.
Enhanced Collaboration: Implement Git integration for smoother collaboration and improved productivity.
Practical Implementation: Walk through the practical steps to transform a PBIX file into a versioned, scalable model using Visual Studio Code.

Target audience:
BI Devs, Tech-savvy data analysts regularly working with Power BI and looking to improve their workflow efficiency, collaboration and complex model management.
Also, users who have a foundational understanding of Power BI and are interested in advanced techniques and tools to optimize their workflows.
Admins responsible for setting up and maintaining the technical infrastructure, including source control and versioning systems, in an enterprise environment.

From Power BI Admin to Fabric Admin: Governance, Monitoring, and Capacity in Practice

Are you comfortable building reports in Power BI, but less sure what happens after you publish them? Or have you suddenly found yourself responsible for administering Fabric as well?

I’ve worked as a Power BI and Fabric administrator and now regularly help organizations with Power BI and Fabric governance. The questions I hear are often practical ones: Which tenant settings matter? How should we keep an eye on capacity? Where do we start when something is slow—or when nobody knows what is using the resources?

In this full-day, hands-on masterclass, we’ll work through the day-to-day responsibilities of a Power BI and Fabric administrator. We’ll look at tenant and workspace governance, permissions and compliance, then explore the Admin Monitoring workspace and Capacity Metrics app to investigate usage, performance, and capacity pressure. We’ll use practical scenarios to discuss capacity planning, bursting and smoothing, cost management, alerts, and troubleshooting, and where automation can help.

You’ll leave with a clearer picture of what to monitor, which tools to reach for, and how to turn what you find into sensible next steps. Bring your questions and challenges; we’ll make time to work through them together.

Suggested target audience:
* Power BI administrators who are starting to take on Fabric responsibilities
* BI developers or technical leads who help manage their organization’s Fabric environment
* IT professionals involved in workspace governance, monitoring, or capacity planning
* It’s also suitable for people newly assigned as Fabric admins who want a practical overview of the role.

Prerequisites: Familiarity with Power BI and the Fabric Service is helpful. No prior Fabric administration experience is required.

A Deep Dive Into The Power BI Direct Lake

The term storage mode in Power BI refers to how tables are stored and how queries will be sent to the data source. In Power BI desktop you can specify the storage mode on a per-table basis. It's important to understand how the different storage modes function and how they can be utilized to meet certain business requirements.

Power BI has had storage modes for quite some time, with Import being the best practice and default mode for the majority of projects.
With Microsoft Fabric, a new mode has been announced: Direct Lake mode.

How does that fit in? It's actually not really a storage mode (because it doesn’t store any data!), but more a connectivity mode.
What are the differences and similarities or the pros and cons to the old storage modes?
What Power BI or Fabric licenses do we need, to use Direct Lake mode?
What is Delta, Parquet and V-Ordering all about?

In this session we will deep dive into the Direct Lake mode and try to answer these questions.
This sessions is mainly aimed at Power BI developers, so anyone who works with Power BI Desktop, or people that want to get a better understanding of all the storage modes in Power BI. Some experience with Power BI (Desktop) is assumed, so that you have a basic understanding of how Power BI works.

Tips & Tricks of a Large Scale Power BI (Premium) Implementation

Attendees will walk away with guidelines and practical tips from a real-world implementation of Power BI (Premium) with 750+ users.
Back to September 2016: Power BI is new, shiny and hot. It is the tool of the moment, so people cannot wait to get their hands on it.
Fast forward 6 months, there is more traction within the business, trainings are given and workshops are held. The adoption of Power BI is growing. Some departments already use Power BI very extensively and incorporate it in their day-to-day processes. Due to this quick success there is uncertainty regarding the right support team for incidents and problems.
Because an app workspace creates an Office 365 group with a lot of artifacts behind the scenes, the creation workflow is controlled by IT. Unfortunately this inhibits the end users.
We require more governance, not to further bother the users, but it is essential to stay in control. Responsibilities need to be better aligned between IT and the business. And what to do with Power BI Premium?
Throughout this session we take you along on our Power BI journey, with tips, tricks, do's and don'ts during the implementation of Power BI (Premium) at a financial institute in the Netherlands.
For this session a basic knowledge of Power BI is assumed, there is no deep technical knowledge necessary.

This is a 45 min - one hour session (beginner - intermediate) that can be co-presented with my colleague Jeroen Schalken.

Query Folding in Power BI

Are you working with Power Query, in Excel or Power BI? Have you ever experienced that the importing of data is slower than you expected? In most of those cases, query folding is probably not happening fully optimized.
Query folding is important because it offloads data transformations to the source, instead of performing them in Power Query.
Attend this session to learn how to ensure that you get all the performance improvements possible in your reports.
You will learn how to check if a query (really) folds, how to use the Query Diagnostics feature, and even how to make a Native SQL query fold!
You will also see how (not) folding can hurt performance.

This is an intermediate, one hour technical session. A basic understanding of Power BI Desktop is required because it goes under the cover into Power Query.

Power Platform Better Together: Create a Scoring App with a Live Dashboard

Often during a presentation or workshop, you want to have an interactive quiz.
Maybe you've used Kahoot or any of the other platforms out there, but they rarely integrate well with our other applications. Using the Power Platform, we'll create an interactive quiz that gives you the best of all worlds.

Our goal is to create an app where attendees will answer questions and be awarded points for (partially) correct answers.
We want to have an application where we can enter the name of an attendee and their score. Ideally, we'll be showing the results using that same application so there's no constant switching between the app and the results.
We're going to accomplish this by using 3 of the Power Platform products: Power Apps, Power Automate and Power BI.

Join this session to see how to build this solution from scratch!

From Read-Only to Transactional: Mastering Translytical Task Flows

Translytical Task Flows transform Power BI from a reporting tool into an operational action platform. Power BI reports can now trigger transactional operations - updating records, calling external APIs, sending notifications - without users leaving the report. But production deployments reveal hidden complexity: error handling, concurrency, performance degradation, security boundaries, and the critical decision of when to use Task Flows vs. Power Apps vs. Power Automate.
This is a hands-on, deep technical session for developers and architects building operational dashboards. We move beyond "Hello World" button demos into real production patterns.

What you'll learn:
- Translytical fundamentals: User Data Functions (UDFs) as the engine, button actions as the trigger, Fabric data sources as the target
- Architecture patterns: When to use Task Flows, when to embed Power Apps, when to use Power Automate
- Production-grade UDF design: Error handling, retry logic, transaction boundaries, audit logging
- Performance & scaling: Batch vs. row-level operations, connection pooling, query optimization, capacity impact
- Real-world integrations: Sales order approval workflow with Teams notification, inventory updates with validation
- Demo: End-to-end build of a complex task flow with error scenarios, rollback patterns, and monitoring

By the end, you'll have:
- A decision framework: Task Flows vs. Power Apps vs. Power Automate for your use case
- Production-ready UDF templates (error handling, logging)
- Confidence to architect translytical solutions at enterprise scale

<500 chars
Translytical Task Flows transform Power BI from analytics-only to an operational action platform. This deep technical session moves beyond demos into production architecture: error handling, concurrency, security, and the critical decision of when to use Task Flows vs. Power Apps vs. Power Automate.
Learn UDF patterns, real-world integrations, and production-ready code templates with case studies.