Microsoft Fabric Updates Blog

Microsoft Fabric MVP Corner – September 2023

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 blog series “Microsoft Fabric MVP Corner” to highlight selected content related to Fabric and created by MVPs. 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!

 

This month’s MVP content

Alex RostanGaston Cruz

Alex Rostan (Twitter: @rostanker)
Gaston Cruz (Twitter: @gastonfcruz)

Video: Exploring Microsoft Fabric: Dive into Capacities, SKUs, and Pricing Models

Description: Ready to dive into the world of Microsoft Fabric? This video is a guided tour through the intricacies of Fabric’s capacities, SKUs, and pricing models.

Alex RostanGaston Cruz

Alex Rostan (Twitter: @rostanker)
Gaston Cruz (Twitter: @gastonfcruz)

Video: What is OneLake and how I can leverage it?

Description: In this episode of their Microsoft Fabric series Alex and Gaston cover a deep dive on OneLake, the storage foundation of Fabric.

Andy CutlerReid Havens

Andy Cutler (Twitter: @MrAndyCutler)
Reid Havens

Video: Data Warehousing with Microsoft Fabric

Description: With the introduction of Microsoft Fabric in 2023, the scope of data workloads available has expanded to include Power BI, Lakehouse, Warehouse, and Real-time Streaming. In this session we’ll be diving into one of the workloads that Fabric offers, Data Warehousing. We’ll cover a quick introduction to Fabric with a discussion on lakehouse vs warehouse. Then we’ll dive into the SQL engine and look at how to create a Warehouse including objects like tables and stored procedures.

Erwin de Kreuk

Erwin de Kreuk (Twitter: @erwindekreuk)

Article: Azure Open AI and Microsoft Fabric

Description: Embrace the power of data enrichment in Microsoft Fabric with Azure OpenAI! It’s a thrilling journey where we get to unleash creativity and achieve remarkable feats. By teaming up with Spark on Microsoft Fabric or Azure Synapse Analytics, we’re able to shape and create extensive text data in ways that truly showcase OpenAI’s adaptability in defining these transformations.

Erwin de Kreuk

Erwin de Kreuk (Twitter: @erwindekreuk)

Content hub: Microsoft Fabric Content Hub

Description: Stay up-to-date with the latest and most valuable content about Microsoft Fabric, all in one place! From insightful articles and tutorials to engaging videos and community blogs, you’ll find a treasure trove of resources to deepen your understanding.

Gerhard Brueckl

Gerhard Brueckl (Twitter: @gbrueckl)

Blog post: Querying Power BI REST API using Fabric Spark SQL

Description: Power BI is a fundamental part of Fabric, but it can be cumbersome to fetch and analyze Power BI metadata in Fabric. This blog shows how you can easily query the Power BI REST API using simple SQL statements in your Fabric notebook!

Greg Low

Greg Low (Twitter: @greglow)

Podcast: Fabric Down Under show 3 with guest Mark Pryce-Maher discussing SQL Warehousing in Microsoft Fabric

Description: Fabric Down Under show 3 discusses the SQL warehousing experience in Microsoft Fabric with Senior Program Manager Mark Pryce-Maher.

Ignacio Barrau

Ignacio Barrau (Twitter: @ignacho_07)

Blog post: [ES] ¿Por donde comienzo? OneLake intro (“Where do I start? OneLake intro”)

Description: This article helps understand what Onelake is in order to know how to get started with the first Fabric item you should create when you start working with the platform.

Kevin Chant

Kevin Chant (Twitter: @kevchant)

Blog post: Working with Microsoft Fabric Git integration and multiple workspaces

Description: Covers working with Microsoft Fabric Git integration and multiple workspaces. By highlighting one method that you can use in the real-world.

Kevin Chant

Kevin Chant (Twitter: @kevchant)

Blog post: Microsoft Fabric Git integration jargon guide for Fabricators

Description: My Microsoft Fabric Git integration jargon guide for Fabricators. In addition to explaining some jargon, Kevin also provides plenty of links in this post to help.

Kevin Chant

Kevin Chant (Twitter: @kevchant)

Blog post: Share a Microsoft Fabric Data Warehouse Database Project with the new target platform

Description: Covers how you can share a Microsoft Fabric Data Warehouse Database Project with the new target platform. Which is now possible thanks to the latest Azure Data Studio Insiders update.

Kevin Chant

Kevin Chant (Twitter: @kevchant)

Blog post: New Microsoft Fabric Data Warehouse Target Platform is now included as part of the latest Azure Data Studio update

Description: Raises awareness about the fact that the new Microsoft Fabric Data Warehouse Target Platform is now included as part of the latest Azure Data Studio update (version 1.46).

Marc Lelijveld

Marc Lelijveld (Twitter: @MarcLelijveld)

Blog post: Add service principal to Fabric workspace using Power BI REST API

Description: Lately, Marc couldn’t get it to work adding a service principal to a Fabric workspace using the Power BI REST API although it seems very straight forward reading the documentation. After consulting others, he managed to get it to work and wrote a blog about it. Want to know where that Object ID comes from that the documentation refers to? Read it in this post.

Mariano Kovo

Mariano Kovo (Twitter: @Mariano_Kovo)

Blog post: [ES] Microsoft Fabric – La nueva Solución de Analytics (“Microsoft Fabric – The new Analytics Solution”)

Description: An introduction to Fabric and all its components in Spanish.

Mohammed Adnan

Mohammed Adnan (Twitter: @mohammedadnant)

Video: Microsoft Fabric Masterclass

Description: 2 hours of Microsoft Fabric Masterclass – Mohammed covers how to use the features and mainly covers WHY aspect of the product, why use specific features. He goes deep dive into Fabric.

Mohammed Adnan

Mohammed Adnan (Twitter: @mohammedadnant)

Video: Microsoft Fabric Life Cycle Management – ALM in Fabric

Description: Microsoft Fabric’s lifecycle management tools provide a standardized system for communication and collaboration between all members of the development team throughout the life of the product. Lifecycle management facilitates an effective process for releasing products quickly by continuously delivering updated content into production and ensuring an ongoing flow of new features and bug fixes using the most efficient delivery method.

Mohammed Adnan

Mohammed Adnan (Twitter: @mohammedadnant)

Video: Power BI Version Control using GIT and Azure DevOps

Description: Version control in Power BI using GIT and Azure DevOps
this is really cool feature, saves a lot of time and is a multi-developer option.

Renato Lira

Renato Lira (Twitter: @RenatoLira1986)

Blog post: [PT] Dataflow Gen2: A Evolução do Compartilhamento de Dados no Power BI e Fabric
[EN] Dataflow Gen2: A Superior Alternative to Power BI Dataflow for Data Sharing

Description: Dataflow Gen2 oferece desempenho e flexibilidade aprimorados em comparação com seu antecessor, Dataflow Gen1, especialmente para lidar com grandes volumes de dados. A transição de Gen1 para Gen2 levou a melhorias significativas nos tempos de processamento de dados devido à adoção do armazenamento em arquivos delta parquet e a capacidade de manter armazenamento e cálculos separados. | Dataflow Gen2 offers enhanced performance and flexibility compared to its predecessor, Dataflow Gen1, especially for handling large data volumes. The transition from Gen1 to Gen2 has led to significant improvements in data processing times due to an optimized storage of delta parquet in Fabric and the ability to keep storage and calculations separate.

Reza Rad

Reza Rad (Twitter: @Rad_Reza)

Blog post & Video: Data Wrangler VS. Power Query Editor – Microsoft Fabric

Description: Power Query Editor and Data Wrangler are data transformation and preparation tools in Microsoft Fabric. There are similarities between these two tools. However, there are differences, too. It is essential to know the capabilities of each tool to understand which one should be used for what purpose and scenario. In this article, this is our quest.

Reza Rad

Reza Rad (Twitter: @Rad_Reza)

Blog post & Video: Power Query Template: One Giant Leap

Description: Have you ever considered exporting your entire Power Query Editor project as a single object? Have you thought about what benefits this would bring for you? Things such as version control and team development can be on the horizon, bringing the ability to migrate between tools and services easily. Fortunately, such functionality exists, called the Power Query Template. In this article and video, Reza explains what this is, how it works, and the importance of such a feature.

Reza Rad

Reza Rad (Twitter: @Rad_Reza)

Blog post & Video: Microsoft Fabric Domains: Stepping Stones for Data Mesh

Description: Microsoft Fabric introduced a new concept called Domains. Domains are more than just a separation of Fabric data items. They come with a whole lot of security, administration, and governance features, which brings the concept of data mesh into the world of data analytics using Microsoft Fabric. Domains are logical categorizations inside OneLake. In this article and video, Reza explains what domains are in Microsoft Fabric, why they are important, and their associated features and configurations.

 

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!

Related blog posts

Microsoft Fabric MVP Corner – September 2023

April 23, 2024 by Misha Desai

At the recent Fabric Conference, we announced that both code-first automated machine learning (AutoML) and hyperparameter tuning are now in Public Preview, a key step in making machine learning more complete and widely accessible in the Fabric Data Science. Our system seamlessly integrates the open-source Fast Library for Automated Machine Learning & Tuning (FLAML), offering … Continue reading “Introducing Code-First AutoML and Hyperparameter Tuning: Now in Public Preview for Fabric Data Science”

April 18, 2024 by Santhosh Kumar Ravindran

We are excited to announce a new feature which has been a long ask from Synapse Spark customers, Optimistic Job Admission for Spark in Microsoft Fabric.This feature brings in more flexibility to optimize for concurrency usage (in some cases ~12X increase) and prevents job starvation. This job admission approach aims to reduce the frequency of … Continue reading “Introducing Optimistic Job Admission for Fabric Spark”