In this session, Reza shares tips, tricks, and techniques for capturing errors in Power Query and using them to present exception reporting in Power BI. Expect to learn techniques using Power Query and M in Power BI and Dataflow.

Live demo to use Data Factory in Microsoft Fabric to build a Power BI report, starting with a Dataflow Gen2 in a Lakehouse, orchestrating its refresh schedule with a Data Pipeline and using Tabular Editor to build the report. Date: 2024-04-24. Starts at 7 PM CET via MS Teams.

Date: January 26, 2024. An intensive 8-hour workshop on consolidating data into a single source of truth to enable analysis and generate meaningful insights. Focus areas include Microsoft Fabric, Dataflows Gen 2, Pipelines, and Power BI.

In this session, you’ll learn how to get started with Microsoft Fabric by bringing your existing talents with Power BI into the age of data analytics for the era of AI. You’ll explore Data Factory for ingesting data, Lakehouses for flexibility with data lake storage with data warehousing analytics and the groundbreaking Direct Lake dataset mode for analyzing very large data volumes in Power BI reports. By the end, you’ll understand how to use Microsoft Fabric to create end-to-end solutions at limitless scales.

Free 1-Day workshop on how to use Power BI — the business analytics service that gives you a single view of your business data, with the ability to monitor the health of your business using live dashboards, create rich interactive reports and access your data on the go from your mobile devices.

Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expression, and use this knowledge to write fast, robust code. This edition focuses on examples you can build and run with the free Power BI Desktop, and helps you make the most of the powerful syntax of variables (VAR) in Power BI, Excel, or Analysis Services. Want to leverage all of DAX's remarkable capabilities? This no-compromise "deep dive" is exactly what you need. Related Content Video: Introduction to Microsoft Power BI (Video), Data Analysis Fundamentals with Excel (Video) Perform powerful data analysis with DAX for Power BI, SQL Server, and Excel · Master core DAX concepts, including calculated columns, measures, and calculation groups · Work efficiently with basic and advanced table functions · Understand evaluation contexts and the CALCULATE and CALCULATETABLE functions · Perform time-based calculations · Use calculation groups and calculation items · Use syntax of variables (VAR) to write more readable, maintainable code · Express diverse and unusual relationships with DAX, including many-to-many relationships and bidirectional filters · Master advanced optimization techniques, and improve performance in aggregations · Optimize data models to achieve better compression · Measure DAX query performance with DAX Studio and learn how to optimize your DAX

In this session, we explore dynamic format strings and conditional formatting in Power BI to allow end users to flexibly format visuals. We cover the basic concepts of dynamic format strings to customize displayed data based on context and user interactions, and then dive into conditional formatting with rules and expressions to highlight data points. We also demonstrate combining dynamic format strings with conditional formatting to give end users flexibility in what is displayed. By the end, participants will understand how to leverage these features to transform Power BI reports into dynamic, insightful visuals.

In this session, James dives deep into the world of geospatial analytics, showcasing back-to-back demos and exploring the powerful capabilities of Azure Maps and ArcGIS visuals in Power BI. If you’re keen on elevating your data visualization skills, this session is a must-watch!

In today's data-driven landscape, the need for adaptable and versatile reporting is paramount. The challenge often lies in accommodating diverse requirements without overwhelming your report with redundant visuals.\n\nEnter Field Parameters—a robust feature designed to add dynamic flexibility to your reports.\n\nIn this session, attendees will gain hands-on experience in implementing field parameters within a reporting framework. This will empower users to interactively explore their data in a methodical and efficient manner, thereby eliminating the need for multiple static visuals and enhancing the user experience.\nLearn how to make your reports not just informative, but also intuitive and user-friendly through the incorporation of Field Parameters.

Everyone is excited about AI and the impact it can have on data and analytics, and in Power BI that promise is being delivered on with Copilot. In this session you'll learn everything you need to know about Copilot for Power BI: what it is, what it can and cannot do, how much it costs, and how to tune it.

Sam Mitchell - Slalom - Senior Consultant. Sam is going talk through a Power BI report for an internal charity challenge "Tour de Slalom" showcasing the reports, dashboards and visuals.

Session about Microsoft Fabric Notebooks, basics of Python and Spark, using Notebooks to write and run code, leveraging CoPilot for code suggestions and corrections, and using SemPy to enrich Power BI development with advanced analytics.

Graphs are everywhere – from the intricate web of social networks to the scheduling algorithms on our devices. Yet, Power BI traditionally struggles with visualizing graphs. Discover practical strategies for structuring your data and learn how to use Deneb to create compelling, interactive graph visualizations that reveal crucial relationships within your data.

About Jake: Jake Duddy specializes in Business Intelligence and Power BI. He administers a Power BI tenant, and develops processes and tooling to empower developers. Jake champions best practices, having established DevOps processes and robust admin monitoring solutions

Jake is an active member of the Fabric community. He shares his insights through his blog, https://evaluationcontext.github.io/, where he shares his experiments and experiences with topics related to the Microsoft analytic stack. He is a Community Champion on the Fabric Forums, and he frequently presents at Power BI User Groups, sharing his knowledge with a broader audience