Fabric Influencers Spotlight September 2024
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!
