Microsoft Fabric Updates Blog

Microsoft Fabric MVP Corner – July 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

Amit Chandak Amit Chandak (Twitter: @amitchandak78)

Video: Microsoft Fabric Part 18: Dataflow Gen2: Native warehouse Destination- Power Query Transformation – Pivot, Unpivot, Transpose Data

Description: In this video Amit explores native Warehouse connector now available in Dataflows Gen2, along with Power Query transformations – pivot, unpivot, and transpose data. Get “Fabricated” (learn Fabric) with the whole playlist of over 20 videos on Microsoft Fabric by Amit. For source code presented in some of these videos check out Amit’s articles on medium.com.

Amit Chandak Amit Chandak (Twitter: @amitchandak78)

Video: [IN] Microsoft Fabric in Hindi Part 6: How to load data in Warehouse using Data Pipeline | End to End Scenario

Description: In this video Amit presents how to use data pipeline to load data into a Microsoft Fabric warehouse and analyze it using Power BI. For more videos on Microsoft Fabric in Hindi check out the whole playlist by Amit.

Andy Cutler Andy Cutler (Twitter: @MrAndyCutler)

Video: Using Domains in Fabric to group workspaces and isolate workloads

Description: In Fabric, Domains are a way to group workspaces together and provide a way to separate business areas. In this video we’ll look at what Domains look like, how to assign workspaces, then look at allocating workspaces to specific Fabric capacity for dev/test/prod workload isolation.

Andy Cutler Andy Cutler (Twitter: @MrAndyCutler)

Video: Read Transactions and Isolation Levels in Fabric Warehouse

Description: Fabric SQL is just like any other SQL engine, it has the concept of transactions and isolation levels. However, in Fabric SQL we only have 1 isolation level which is Snapshot Isolation. In this video we’ll see how snapshot isolation handles concurrent reading and writing of data.

Chris Wagner
Kevin Arnold
Chris Wagner (Twitter: @kratosbi)
Kevin Arnold (Twitter: @kevarnold)

Video: Fabric Fridays: Learn how to work with Microsoft Fabric #6

Description: Fabric Fridays is a weekly live stream hosted by Chris Wanger and Kevin Arnold, two passionate fabric enthusiasts who love to share their knowledge and opinions on all things related to textiles. Each episode, they explore a different topic, such as the history, science, art, and culture of fabrics, and interview guests who are experts or innovators in the field. Whether you are a professional designer, a hobbyist crafter, or just curious about fabrics, Fabric Fridays will entertain and educate you with fun and informative conversations. In this episode Chris and Kevin discuss starting with Fabric and how it can help you manage your data more efficiently.

Fernando Martins Fernando Martins

Article: [PT] Microsoft Fabric – O que ele não faz? (“Microsoft Fabric – What does it NOT do?”)

Description: Platform overview, the magic of OneLake with delta parquet data format, lakehouse concept, Fabric and Power BI data access.

Gilbert Quevauvilliers Gilbert Quevauvilliers (Twitter: @gilbertQue)

Blog post: Did you know that there is an easy way to shape your data in Fabric Notebooks using Data Wrangler?

Description: It shows how you can shape your data using the data wrangler in Fabric notebooks.

Hariharan Rajendran Hariharan Rajendran (Twitter: @imhariharanr)

Video: How to adopt data mesh in Microsoft Fabric using Domains

Description: This video explains on how to adopt data mesh architecture in Microsoft Fabric and how it can help organizations to achieve their goal on decentralized data architecture for self-service and domain centric use cases. Also, read the article from Hariharan on the same topic.

Hariharan Rajendran Hariharan Rajendran (Twitter: @imhariharanr)

Video: Microsoft Fabric Dataflow Gen2 Complete Guide

Description: This video covers complete end-to-end guide to Microsoft Fabric Dataflow Gen 2.

Ignacio Barrau Ignacio Barrau (Twitter: @ignacho_07)

Blog post: [ES] Intro a Microsoft Fabric la solución Data Platform todo en uno (“Introduction to Microsoft Fabric the all-in-one Data Platform solution”)

Description: En este artículo vamos a introducir características y funcionalidades de la nueva herramienta Fabric de Microsoft que va a intentar tomar todos los roles de data trabajando en un mismo espacio. Aprenderás definición, servicios que involucra, estructura en comparación con PowerBi. Luego daremos apreciación de features principales y pensamientos personales. | In this article, we are going to introduce the characteristics and functionalities of the new Microsoft release called Fabric, which aims to consolidate all data roles into a single workspace. You will learn about its definition, the services it encompasses, and its structure compared to Power BI. We will then provide an overview of its main features and share personal thoughts.

Kathrin Borchert Kathrin Borchert (Twitter: Mirrortears)

Blog post: The Magic of Microsoft Fabric: Simplifying the Complex for All

Description: In today’s fast-paced digital world, technology plays a vital role in empowering businesses and individuals. However, it’s no secret that navigating the complex landscape of technology can often be daunting. Enter Microsoft Fabric, a remarkable solution that brings the magic of simplicity to the forefront. In this blog post, we’ll explore the enchanting qualities of Microsoft Fabric and highlight why it will be become an essential tool for businesses and users worldwide.

Kevin Chant Kevin Chant (Twitter: @kevchant)

Blog post: Migrate serverless SQL Pool objects to a Microsoft Fabric Data Warehouse

Description: Covers one way you can migrate serverless SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure DevOps. Since Kevin was able to get this working.

Kevin Chant Kevin Chant (Twitter: @kevchant)

Blog post: Migrate dedicated SQL Pool objects to a Microsoft Fabric Data Warehouse

Description: Covers one way you can migrate dedicated SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure DevOps. Includes a link to a GitHub repository which you can download and use as a template within Azure DevOps.

Marc Lelijveld Marc Lelijveld (Twitter: @MarcLelijveld)

Blog post: Governance in Microsoft Fabric: Understanding the Roles and Domains

Description: Microsoft Fabric is out there for a few weeks now. With the release of Fabric, a new concept in line with data-mesh architectures became available in Fabric, or Power BI if you will. With the introduction of Domains, we have a new level of controls added next to existing roles. In this blog Marc further elaborates on the levels of control that are available today and provides a clear overview of these different levels.

Marc Lelijveld Marc Lelijveld (Twitter: @MarcLelijveld)

Blog post: Designing Architectural Diagrams with the Latest Microsoft Fabric Icons

Description: With Fabric, a bunch of new services and icons have been introduced. This asks for a new draw.io file to make it easier for you to create architectural diagrams. With this blog, the new library is provided and can directly be used in draw.io.

Parvinder Chana Parvinder Chana (Twitter: @parvchana)

Video: Dataflow Gen2 and Pipeline in Data Factory: A Game-Changing Duo in Fabric

Description: In this comprehensive Fabric tutorial, we delve into the transformative capabilities of Dataflow Gen2, and Data Pipeline within Data Factory, demonstrating their combined potential to revolutionize data management practices. For more videos check out the Microsoft Fabric playlist by Parvinder.

Reza Rad Reza Rad (Twitter: @Rad_Reza)

Blog post and video: Power BI Direct Lake – What is it and Why it is Important When Working With Fabric

Description: With the Microsoft Fabric announcement there are also additional features in Power BI that make the connection between Power BI and other Microsoft Fabric objects seamless and more profound. One of these features is the Direct Lake connection in Power BI. In this article and the video, we’ll talk about the Direct Lake, how it differs from other types of connections in Power BI, and how you can use it in an example.

Rishi Sapra Rishi Sapra (Twitter: @rsaprano)

Blog post: Microsoft Fabric Key Concepts: Your Questions Answered!

Description: A list of 10 questions and answers on key concepts of Microsoft Fabric.

Soheil Bakhshi Soheil Bakhshi (Twitter: @_SoheilBakhshi)

Blog post: Microsoft Fabric: A SaaS Analytics Platform for the Era of AI

Description: The blog post explains the fact that Microsoft Fabric integrates various data and analytics services into a single product. Fabric covers everything from data movement to data science, real-time analytics, and business intelligence. Microsoft Fabric is built upon the Power BI platform and provides industry-leading visualisation and AI-driven analytics.

Soheil Bakhshi Soheil Bakhshi (Twitter: @_SoheilBakhshi)

Blog post: Microsoft Fabric: Terminologies and Personas Explained

Description: This blog post provides an explanation of key concepts, personas, and terminologies related to Microsoft Fabric. It emphasises that users can interact with the platform based on their roles and personas, such as data engineers, data scientists, business analysts, and data stewards. The post introduces terms like tenant, capacity, and workspace, which are used within the platform. It also highlights the significance of personas and experiences, which represent specific user roles and tailored feature sets. Understanding these concepts and terminologies helps users navigate and leverage the platform effectively.

Stepan Resl Štěpán Rešl (Twitter: @tpnRel1)

Article: Lessons learnt from PySpark Notebooks and extracting APIs

Description: From Štěpán: “I prepared information I wish I had known about Fabric Notebooks when I started with them”. In addition to the basic overview, this article also focuses on using notebooks to get data from the API.

Stepan Resl Štěpán Rešl (Twitter: @tpnRel1)

Cheat sheet: Microsoft Fabric Licensing Cheatsheet

Description: It is a prepared cheat sheet that shows which artifacts from the Power BI and Fabric world we can use with which licenses.

 

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!

Billets de blog associés

Microsoft Fabric MVP Corner – July 2023

octobre 31, 2024 par 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”

octobre 29, 2024 par 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”