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!

Liittyvät blogikirjoitukset

Microsoft Fabric MVP Corner – September 2023

lokakuuta 31, 2024 tekijä 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”

lokakuuta 29, 2024 tekijä 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”