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 Rostan (Twitter: @rostanker) 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 Rostan (Twitter: @rostanker) 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 Cutler (Twitter: @MrAndyCutler) 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 (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 (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 (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! |
|
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 (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 (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 (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 (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 (Twitter: @kevchant) 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 (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 (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 (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 (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 (Twitter: @mohammedadnant) Video: Power BI Version Control using GIT and Azure DevOps Description: Version control in Power BI using GIT and Azure DevOps |
|
Renato Lira (Twitter: @RenatoLira1986) Blog post: [PT] Dataflow Gen2: A Evolução do Compartilhamento de Dados no Power BI e Fabric 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. |
|
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. |
|
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. |
|
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!