Fabric Influencers Spotlight September 2024

[riirish]

Welcome to the September edition of the Fabric Influencers Spotlight, a recurring monthly post here to shine a bright light on the places on the internet where Microsoft MVPs & Fabric Super Users are doing some amazing work on all aspects of Microsoft Fabric.

The Microsoft Fabric Community team has created the Fabric Influencers Spotlight to highlight and amplify blog posts, videos, presentations, and other content related to Microsoft Fabric. We’ve cultivated submissions from members of Microsoft MVPs & Fabric Super Users from the Fabric community that cover the Fabric Platform, Data Engineering & Data Science in Fabric, Data Warehousing, Power BI, Real-Time Intelligence, Data Integration, Fabric Administration & Governance and Databases. 

Microsoft Most Valuable Professionals, or MVPs, are technology experts who utilize their deep knowledge of Microsoft products and services to bring together diverse platforms, products, and solutions, to solve real world problems, and to bring “leading edge” content to the data community. To learn about the Microsoft MVP Award and to find MVPs, visit the official website.

Fabric Super Users are the heroes of the Fabric Community. They contribute helpful answers, write informative blog posts, post data stories and are key contributors to the Fabric product via engagement with the product group. To learn more about becoming a Fabric Super User, visit our most recent post: What is the Fabric Super User program?

FabCon Europe

Kevin Chant, Twitter, LinkedIn
Affiliation: Microsoft MVP

Announcing DP-700 the Newest Microsoft Fabric Certification
All about the DP-700 exam, the newest certification for Microsoft Fabric. First, it's not a replacement for the DP-600 exam. Think of the new certification as a Microsoft Fabric variant of the existing Azure Data Engineer Associate certification.

Joey D'Antoni, Twitter, LinkedIn

Microsoft Fabric Conference Europe Recap

The European Microsoft Fabric Community Conference (Fabcon EU), which was a showcase of Microsoft's continued investments in the Fabric software-as-a-service platform.

Data Warehouse

Jon Stjernegaard Vöge, Community Profile, LinkedIn
Affiliation: Fabric Super User

How to share Fabric / Power BI Semantic Models with External Users

Microsoft Fabric allows us to share Semantic Models directly with external users. This enables several interesting use cases. Externals may enhance your model with new measures, build their own reports with your semantic model and data, and publish them to their own tenant. Read this blog to learn how.

Amit Chandak, Twitter, LinkedIn
Affiliation: Microsoft MVP & Fabric Super User

How to Create and Manage Table Clones in Microsoft Fabric Warehouse |Time Travel using Clone

How to efficiently create, manage, and delete table clones in Microsoft Fabric with this step-by-step tutorial. In this video, I walk you through the process of creating zero-copy clones, both at the current point in time and with historical timestamps. We also demonstrate how to delete clones and the original table and explain the impact of these actions on your data.

Power BI

Ilgar Zarbaliyev, Twitter, LinkedIn
Affiliation: Microsoft MVP

Mastering the RANKX DAX Function: Tips, Tricks, and Common Pitfalls to Avoid

Mastering the RANKX DAX Function: Essential Tips, Expert Tricks, and How to Avoid Common Mistakes

Ville Gullstrand, LinkedIn
Affiliation: Microsoft MVP

Endless Calculations to the People

In this blog post I describe how to create a fully customizable page in Power BI for users. Sometimes it's hard to know in advance what exact aggregations and comparisons the end user want to make. This solution creates sort of like a calculator inside Power BI where the user can choose freely.

Hariharan Rajendran, LinkedIn
Affiliation: Microsoft MVP

SQL Analytics Endpoints in Microsoft Fabric and Power BI Desktop

This video explains how Microsoft Fabric handles the SQL analytics endpoint under the hood, covers some internals of SQL endpoint and how you can easily access the SQL endpoint from Power BI Desktop.

Data Engineering

David Abiola, Twitter, LinkedIn
Affiliation: Microsoft MVP

Incremental Data Loading from SharePoint Folder to Fabric Warehouse

In the new data engineering episode, I demonstrated how to implement robust incremental data loading from SharePoint folder to Fabric Warehouse leveraging Fabric Data Factory. This post covers many topics from creating Fabric Dataflow Gen2 to creating a Fabric Data Warehouse and tables to creating a pipeline with lookup dataflow, copy data and stored procedure activity.

Tharun Kumar Ravikindhi, Community Profile, LinkedIn
Affiliation: Fabric Super User

Efficiently Processing Massive Data Volumes using Microsoft Fabric: A Comprehensive Guide

In this article, you will learn how to process massive volumes of data using Microsoft Fabric workloads.

Data Science

Sandeep Pawar, Twitter
Affiliation: Microsoft MVP

Querying SQL Endpoint of Fabric Lakehouse/Warehouse In A Notebook With T-SQL

This blog post shows how to query a Fabric Lakehouse or Warehouse SQL Endpoint using T-SQL in a notebook with the spark connector.

Fabric Platform, Administration & Governance

Kevin Chant, Twitter, LinkedIn
Affiliation: Microsoft MVP

Unit tests on Microsoft Fabric Items

Shares various ways that you can perform unit tests on Microsoft Fabric items. Since a lot of people ask about unit testing in Microsoft Fabric these days and I want to provide some options, so we'll work on test on individual components.

Omer Colakoglu, Twitter, LinkedIn
Affiliation: Microsoft MVP

Let's talk data in Microsoft Fabric with Olcay Çelik

Omer and Olcay Çelik (both Data Platform MVPs from Turkey) discuss what is Microsoft Fabric, what are the essential concepts, lakehouse, data lake etc.

Soheil Bakshi, Twitter
Affiliation: Microsoft MVP

Automate Fabric Capacity Scaling with Azure Logic Apps

In this video, I guide you through the complete process of creating a new Logic Apps workflow for automating Microsoft Fabric capacity scaling. The video also covers the common admin permission issues you might face during the setup and demonstrates detailed steps to troubleshoot and resolve them effectively.

Real-time Intelligence

Ryoma Nagata, Twitter
Affiliation: MVP

Step-by-Step Guide to Analyzing Amazon Kinesis Data in Real-time with Microsoft Fabric

This guide provides a step-by-step approach to analyzing Amazon Kinesis Data Streams in real-time using Microsoft Fabric Real-time Intelligence. It covers key processes such as setting up data ingestion from Kinesis, storing and querying data in Eventhouse, and visualizing the results with Real-time Dashboards. Additionally, the guide explores monitoring the stream data with Reflex for real-time alerts and notifications based on thresholds.

Thanks for reading & we'll see you next month!

That’s all for this month’s spotlight on the Microsoft Fabric Influencers. We wanted to extend our thanks to the MVPs and Super Users whose expertise continues to enrich the Fabric community. We anticipate the innovative ideas and valuable insights that will emerge in the coming months and invite everyone to stay engaged here on the Fabric Community Platform. Together, we will continue to deliver knowledge and collaboration that empowers every member of our community to achieve more. Stay tuned!