Microsoft Fabric Updates Blog

Microsoft Fabric MVP Corner – Special Edition (Ignite)

About this blog series

Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get their hands on new, exciting technologies. They have very deep knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products, and solutions, to solve real world problems. To learn about the Microsoft MVP Award and to find MVPs, visit the official website: https://mvp.microsoft.com/.

The Microsoft Fabric team presents you with a special edition of the “Microsoft Fabric MVP Corner” blog series to highlight selected content related to Fabric and created by MVPs around the Microsoft Ignite 2023 conference when we announced Microsoft Fabric generally available.

Dive into a collection of content created by MVPs that includes blogs, videos, articles, live streams, podcasts, and more. Delve into these valuable resources and immerse yourself in the wealth of knowledge and insights shared by our esteemed MVP community. Enjoy reading, watching, and listening to these informative resources!

 

MVP content

Amit Chandak

Amit Chandak (Twitter/X: @amitchandak78)

Video: Create calculation group on a custom dataset in Microsoft Fabric using Tabular Editor 3

Description: In this video Amit presents how to create calculation groups on custom datasets in Microsoft Fabric using Tabular Editor 3. This video is a part of almost 40-part series on Microsoft Fabric.

Amit Chandak

Amit Chandak (Twitter/X: @amitchandak78)

Video: Unlocking Power BI Potential: Direct Lake on Warehouse

Description: Discover the groundbreaking features in the latest Microsoft Fabric release! In this video Amit dives deep into the exciting new capabilities of Power BI semantic models, focusing on the Direct Lake mode for Synapse Data Warehouses.

Amit Chandak

Amit Chandak (Twitter/X: @amitchandak78)

Blog post: Unlocking Data Insights: A Guide to Essential Microsoft Fabric Resources

Description: As you embark on your journey with Microsoft Fabric, having access to comprehensive resources is crucial for maximizing its potential. This blog serves as a comprehensive guide to essential Microsoft Fabric resources, providing you with the knowledge and tools you need to navigate the platform effectively.

Andy Cutler

Andy Cutler (Twitter/X: @MrAndyCutler)

Video: New Microsoft Fabric Certification Announced! Fabric Analytics Engineer Associate

Description: At Microsoft Ignite 2023 a new Associate Certification was announced. The DP-600 Microsoft Fabric Analytics Engineer Associate. Yes, ANALYTICS ENGINEER! In this video Andy goes through some thoughts about the exam, pulls out the interesting parts, and tries and ties the whole thing together with all the services that are being tested.

Bernat Agullo Rosello

Bernat Agulló Roselló (Twitter/X: @AgulloBernat)

Blog post: Orchestrating Dataset Refreshes with Power Automate and Power Apps (Part 2)

Description: In this blog post Bernat shows (among other things) how to leverage Dataflows Gen 2 and lakehouses to bring data into a PowerApp through the SQL Endpoint.

Brian Bønk

Brian Bønk

Blog post: KQL data live in OneLake

Description: We now have the Real-Time Analytics experience generally available along with Microsoft Fabric. Also, we’ve just got the ability to have the KQL data available live in OneLake. In this blogpost Brian guides through the setup and thoughts on the new possibilities.

Brian Bønk

Brian Bønk

Blog post: Fabric – Constraints for the Lazy Coder

Description: This blog post comes with some help and guidance on working with semantic models over warehouses in Fabric and dealing with constraints created automatically in warehouses.

Chris Wagner

Chris Wagner (Twitter/X: @KratosBi)

Video: Welcome to Microsoft Fabric

Description: Welcome to Microsoft Fabric, the ultimate data platform that will change the way you work with data! In this video, you will learn: what Microsoft Fabric is, why use it and how to get started with it.

Chris Wagner

Chris Wagner (Twitter/X: @KratosBi)

Video: Eliminate Shadow IT with Microsoft Fabric

Description: In this video, Chris dives deep into the powerful world of Microsoft Fabric and reveals how it can revolutionize your data management and bring unprecedented efficiency to your operations.

Chris WagnerKevin Arnold

Chris Wagner (Twitter/X: @KratosBi)
Kevin Arnold (Twitter/X: @kevarnold)

Video: Fabric Fridays: Microsoft Ignite Summary and Copilot Fabric

Description: In this video, Chris and Kevin run down the big announcements and talk through how Copilot works in Power BI. Check the recordings of other episodes of Fabric Fridays.

David Abiola

David Abiola (Twitter/X: @AbiolaDavid01)

Video: Data Pipeline to Copy Data from Data Warehouse to Lakehouse in Microsoft Fabric

Description: In this video, David shows how to create a smooth pathway for data transfer from a Data Warehouse to a Lakehouse using Microsoft Fabric.

David Abiola

David Abiola (Twitter/X: @AbiolaDavid01)

Article: Fabric Data Warehouse: Save as Table and Analyze Result Functionalities

Description: In this article, David focuses on Microsoft Fabric Data Warehouse Save as Table and Analyze Result functionalities that offer several benefits to end users and data analysts.

Ignacio Barrau

Ignacio Barrau (Twitter/X: @ignacho_07)

Blog post: [ES] Entre Archivos y Tablas de Lakehouse – SQL Notebooks (“Between Lakehouse Files and Tables – SQL Notebooks”)

Description: Cuanto más trabaja Ignacio en Fabric, más se sorprende del SaaS y la baja capacidad de código que generaron para todas las etapas del proyecto. Un ejemplo de simplicidad fue copiar datos con Data Factory. En este artículo veremos otro ejemplo para que los aficionados a SQL puedan trabajar la ingeniería de datos o el modelado dimensional desde un cuaderno. | The more Ignacio works Fabric, the more surprised he is about the SaaS and low code capacity they generated for all the project stages. An example of simplicity was copying data with Data Factory. In this article we will see another example so that SQL fans can work on data engineering or dimensional modeling from a notebook.

Ignacio Barrau

Ignacio Barrau (Twitter/X: @ignacho_07)

Blog post: [ES] Nuevo tipo de conexión – Direct Lake (“New connection type – Direct Lake”)

Description: En este artículo vamos a conocer más sobre la conexión Direct Lake. Veremos porque tanto revuelo y que tiene que las otras formas no tengan o porque la elegiríamos. | In this article we are going to learn more about the Direct Lake connection. We will see why there is so much fuss and what it has that the other forms do not have or why we would choose it.

John White

John White (Twitter/X: @diverdown1964)

Blog post: Understanding Storage Costs for Microsoft Fabric

Description: A guide to understanding where, when and how much to expect when it comes to storage costs for Microsoft Fabric.

Just Blindbaek

Just Blindbæk (Twitter/X: @JustBlindbaek)

Blog post: Demystifying the Data Lakehouse in Microsoft Fabric

Description: Just himself has a background in classical BI and Data Warehouse on SQL Server and Azure SQL DB. But the focus in Fabric seems to be on the Lakehouse. Data Lakehouse that everyone is talking about now? Should we all start learning Python? What about good old SQL? Why Bronze/Silver/Gold now? Read the blog post to find some answers to these questions.

Kevin Chant

Kevin Chant (Twitter/X: @kevchant)

Blog post: Thoughts about the Microsoft Fabric journey to becoming Generally Available

Description: Shares Kevin’s thoughts about the Microsoft Fabric journey to becoming Generally Available (GA). Which was announced by Microsoft today during the Ignite conference.

Kevin Chant

Kevin Chant (Twitter/X: @kevchant)

Blog post: Thoughts about the DP-600 exam for the new Microsoft Fabric certification

Description: Shares Kevin’s thoughts about the DP-600 exam for the new Microsoft Fabric certification. Along with some insights and plenty of links. Since he covered his thoughts about a Microsoft Fabric certification back in August.

Kevin Chant

Kevin Chant (Twitter/X: @kevchant)

Blog post: Power BI Project (PBIP) and Azure DevOps CI performance tests

Description: Covers some Power BI Project (PBIP) and Azure DevOps CI performance tests that Kevin recently performed.

Kevin Chant

Kevin Chant (Twitter/X: @kevchant)

Blog post: Spreading your SQL Server wings with Microsoft Fabric Data Warehouses

Description: In this post Kevin covers spreading your SQL Server wings with Microsoft Fabric Data Warehouses. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. From Kevin: “I thought it was fitting to do this post now that Microsoft Fabric has become Generally Available (GA)”.

Marc Lelijveld

Marc Lelijveld (Twitter/X: @marclelijveld)

Blog post: Debunking Myths and Embracing Innovation with Microsoft Fabric

Description: Over the past months, Marc has been engaging with many clients with regards to Microsoft Fabric. Many clients had a somewhat hesitant approach given Fabric was still in preview and they did not want to bring their (entire) data estate to Fabric. Microsoft launched Fabric as General Available during the annual Microsoft Ignite conference, so no reason to hold back anymore! Right? Well, there is more that comes to the table other than only the status of the platform. Read Marc’s blog post to learn more.

Michelle Gutzait

Michelle Gutzait

Blog post: Top 5 reasons to use Microsoft Fabric

Description: This blog post provides Michelle’s own opinion and vision of Microsoft Fabric recently announced as generally available. Read it to find out what Michelle finds out as the top 5 reasons to consider using Microsoft Fabric in her future projects.

Michiel Rozema

Michiel Rozema

Article: How I fell in love with Microsoft Data Activator

Description: Data Activator is a component of Fabric that is still in preview. Yet, it may be the ultimate product to provide business value, allowing users to automate taking action on insights, without writing a single line of code. This article explains how, giving a high-level overview of what you can do with Data Activator.

Mike CarloTommy Puglia

Mike Carlo (Twitter/X: @PowerBITips)
Tommy Puglia (Twitter: @tommypuglia)

Video: Intro to GIT Integration – Let’s Learn Fabric – ep.19

Description: In this video Mike and Tommy provide an introduction to GIT integration with Microsoft Fabric. Check the Learn Fabric playlist with 20 videos on Fabric by Mike and Tommy.

Mohammed Adnan

Mohammed Adnan (Twitter/X: @Mohammedadnant)

Video: SCD Type 2 implementation in Fabric Data Warehouse (Slowly Changing Dimension SCD Type 2)

Description: In this video Mohammed covers how to implement SCD Type 2 in Microsoft Fabric data warehouse using a combination of Dataflows Gen2 and T-SQL stored procedure.

Mohammed Adnan

Mohammed Adnan (Twitter/X: @Mohammedadnant)

Video: How to solve Fabric and Power BI Azure DevOps GIT Merge Conflict

Description: In this video Mohammed demonstrates how to handle merge conflict issue in CI/CD processes for Fabric and Power BI implemented with Azure DevOps and Git integration.

Mohammed Adnan

Mohammed Adnan (Twitter/X: @Mohammedadnant)

Video: Implement RLS and CLS from Fabric Data Warehouse to Power BI

Description: In this video Mohammed demonstrates how to implement Row-Level Security (RLS) and Column Level Security (CLS) in Microsoft Fabric data warehouse which carry forward to Power BI.

Nandan Hedge

Nandan Hegde (Twitter/X: @nandan_hegde15)

Blog post: Automated Way to Extract Data from Power BI Dataflow via MSFT Fabric

Description: It is possible to copy/extract data from Power BI semantic model by leveraging the Power BI REST API. But unlike Power BI semantic models, Power BI Dataflows don’t have any native API for the data extraction purposes. Read the blog post to find out how to extract data from Power BI Dataflows in an automated way using Dataflows Gen2 in Microsoft Fabric.

Nicky van Vroenhoven

Nicky van Vroenhoven (Twitter/X: @nickyvv)

Blog post: Ignite News: Microsoft Fabric is Now GA (and more)!

Description: The blog post announces the general availability of Microsoft Fabric, “the most significant data product launch since SQL Server” according to CEO Satya Nadella. Copilot in Fabric is now in public preview, offering new features and updates. Mirroring is introduced for managing cloud data warehouses in Fabric’s Data Warehouse experience. The post also covers changes in pricing, including reserved pricing availability, and teases upcoming OneLake integration for Import-mode semantic models.

Nikola Ilic

Nikola Ilic (Twitter/X: @DataMozart)

Blog post: Microsoft Fabric Pricing Model – Everything you need to know!

Description: Now that we know all the pricing details for Microsoft Fabric, let’s examine what are our options to save some money in the wallet.

Nikola Ilic

Nikola Ilic (Twitter/X: @DataMozart)

Blog post: Bursting and Smoothing – Yin and Yang of the Fabric Capacity!

Description: Learn about two key concepts that balance your Fabric capacity workload, and how to save the money along the way!

Nikola Ilic

Nikola Ilic (Twitter/X: @DataMozart)

Blog post: Working with tables in Microsoft Fabric Lakehouse – Everything you need to know!

Description: Working with tables in the Microsoft Fabric lakehouse may look like a straightforward task – however, there are many nuances to be aware of before you decide to go one way or another

Nikola Ilic

Nikola Ilic (Twitter/X: @DataMozart)

Video: DP600 New MS Fabric Analytics Engineer Certificate – Initial thoughts and how it compares to DP500!

Description: Microsoft has just announced the latest certification – Microsoft Fabric: Fabric Analytics Engineer Associate along with the required exam DP-600. Watch the video to find out what’s in this new exam, how it compares to the existing DP-500 certificate, and what resources you can use to prepare for the new exam.

Reid Havens

Reid Havens

Video: Why OneLake is a BIG DEAL in Microsoft Fabric (with Pawel Potasinski)

Description: The video walks through the features and benefits of the OneLake environment. Especially connections with Direct Lake, and reducing data siloing.

Reid Havens

Reid Havens

Video: Building a Digital Nervous System using Data Activator (with Will Thompson)

Description: In this video Will does a full walkthrough of the new data activator platform, current and upcoming features.

Reza Rad

Reza Rad (Twitter/X: @Rad_Reza)

Article & video: Data Science in Microsoft Fabric

Description: Microsoft Fabric, as an end-to-end SaaS, provides multiple experiences, including Data Science. In this article and video, you will learn the Data Science experience in Microsoft Fabric, what it includes, and how it works with other Fabric workloads.

Reza Rad

Reza Rad (Twitter/X: @Rad_Reza)

Article & video: Fabric Real-Time Analytics

Description: Microsoft Fabric offers an experience for real-time solutions. Real-time Analytics can be used for streaming data, such as the data coming from IoT devices. It can be used not only to ingest the data but also to analyze it and use it for other Fabric experiences, such as data science. In this article and video, you will learn what is Real-Time Analytics in Microsoft Fabric and how it works.

Reza Rad

Reza Rad (Twitter/X: @Rad_Reza)

Article & video: Version Control in Power BI and Fabric

Description: Power BI and Microsoft Fabric use Azure DevOps as the core component for their version and source control. The integration with Azure DevOps and Git helps maintain a copy of the source code and version it. It allows access to it anytime needed, plus the multi-development aspect added. In this article and video, you will learn how this integration works.

Soheil Bakhshi

Soheil Bakhshi (Twitter/X: @_SoheilBakhshi)

Blog post: Microsoft Fabric: Capacity Options and Cost Management, Part 1; The Basics

Description: Explore the intricacies of Microsoft Fabric capacities on Azure in Soheil’s latest blog post. Uncover the several types of capacities, grasp the pricing nuances, and discover practical methods to control your costs efficiently.

Soheil Bakhshi

Soheil Bakhshi (Twitter/X: @_SoheilBakhshi)

Blog post: Microsoft Fabric: Capacity Cost Management Part 2, Automate Pause/Resume Capacity with Azure Logic Apps

Description: This blog guides through cost-effective management of Microsoft Fabric capacities using Azure Logic Apps. By automating pause and resume processes, the post outlines a reliable solution for optimal resource utilisation in data and analytics workloads. Recognising the limitations of manual methods, it introduces step-by-step instructions for creating Logic Apps workflows, ensuring error-free alignment of Fabric capacity with actual usage. The blog highlights a bonus section on customizing workflows to fit more specific use cases.

Stepan Resl

Štěpán Rešl (Twitter/X: @tpnRel1)

Blog post: Copy Activity, Dataflows Gen2, and Notebooks vs. SharePoint Lists

Description: In a time of Fabric, it’s worth pointing out there are multiple options for data ingestion from SharePoint lists: 1) Data Pipelines with Copy Activity, 2) Dataflows Gen 2, 3) Notebooks. Read this blog post to understand ​​what each option can offer and how they compare with each other in terms of performance, cost and capabilities.

Warner Chaves (Twitter/X: @warchav)

Podcast: Episode 75 – Recapping PASS Summit And Microsoft Ignite Announcements With Marcelo Adade

Description: In this episode Warner is joined by Marcelo Adade to discuss the latest announcements from the PASS Data Summit and Microsoft Ignite! These include the general availability of Microsoft Fabric, new GenAI capabilities, new cloud integrations, new AI models, new AI SDKs and more!

Wolfgang Strasser

Wolfgang Strasser (Twitter/X: @wstrasser)

Blog post: Microsoft Ignite 2023 – What’s in for us as data professionals?

Description: In this blog post, Wolfgang summarizes the data-related announcements from the Microsoft Ignite keynotes as well as some major new features mentioned in Ignite sesions.

Wolfgang Strasser

Wolfgang Strasser (Twitter/X: @wstrasser)

Video: [DE] Microsoft Fabric ist verfügbar! Was ist das überhaupt? Was kann ich damit machen? (“Microsoft Fabric is available! What is that? What can I do with it?”)

Description: Dieses Video beschreibt die Möglichkeiten von Microsoft Fabric, die Motivation von Microsoft für eine neue Analytics-Plattform und gibt einen Überblick über die enthaltenen Möglichkeiten. | This video describes the capabilities of Microsoft Fabric, Microsoft’s motivation for a new analytics platform, and provides an overview of the capabilities included.

Wolfgang Strasser

Wolfgang Strasser (Twitter/X: @wstrasser)

Blog post: The Microsoft Fabric Corenote at Microsoft Ignite – Demos and Feature summary

Description: For those of you not able to join the session live in Seattle and unable to watch the (free) recording, Wolfgang summarized the main announcements in this blog post.

Call to action

  • Read or watch the content listed above.
  • If you like the content, subscribe to the blogs or YouTube channels of the MVPs.
  • Follow the MVPs mentioned above on Twitter.
  • Stay tuned for more “MVP Corner” blog posts!

Susiję tinklaraščio įrašai

Microsoft Fabric MVP Corner – Special Edition (Ignite)

spalio 31, 2024 – Jovan Popovic

Fabric Data Warehouse is a modern data warehouse optimized for analytical data models, primarily focused on the smaller numeric, datetime, and string types that are suitable for analytics. For the textual data, Fabric DW supports the VARCHAR type that can store up to 8KB of text, which is suitable for most of the textual values … Continue reading “Announcing public preview of VARCHAR(MAX) and VARBINARY(MAX) types in Fabric Data Warehouse”

spalio 29, 2024 – Dandan Zhang

Managed private endpoints allow Fabric experiences to securely access data sources without exposing them to the public network or requiring complex network configurations. We announced General Availability for Managed Private Endpoint in Fabric in May of this year. Learn more here: Announcing General Availability of Fabric Private Links, Trusted Workspace Access, and Managed Private Endpoints. … Continue reading “APIs for Managed Private Endpoint are now available”