dataMinds News Round up –
September 2024
Author: Jason Himmelstein
In this detailed update from Jason Himmelstein, explore the latest innovations and enhancements within Microsoft Fabric for August 2024. Jason zoom in on key updates such as the V-Order behavior of Fabric Warehouses, which allows for enhanced management at the warehouse level. Additionally, the introduction of monitoring ML experiments from the Monitor Hub simplifies the integration of experiment items, while the modernized Data Pipeline experience makes connecting to Azure resources easier than ever.
Author: Sandeep Pawar
In this latest post, Sandeep Pawar shares his experimental journey of developing the AI Skillet, an app designed to access Fabric AI Skills through a local browser. As a regular tester of Fabric AI Skills, Sandeep has previously explored various uses of the AI Skills endpoint, and in this update, he delves into the potential of using it locally to open up new possibilities for integration across different tools, both inside and outside the Fabric ecosystem.
Author: Temidayo Omoniyi
In this article, Temidayo outlines the process of designing a real-time streaming platform using Azure. With the explosion of data from sources such as messaging apps like WhatsApp, financial markets like the NYSE, and video platforms like YouTube, data engineers and solution architects face the challenge of capturing and processing this data in real time. The scope of this exercise includes creating a near-to-real-time streaming data pipeline from the Yahoo finance platform. The stream data is expected to be stored in a data lake and viewed in real-time in Power BI to make informed decisions by business users.
Author: Reza Rad
In this insightful update, Reza introduces Power BI’s new Direct Lake connection to Microsoft Fabric Lakehouse or Warehouse. This connection functions similarly to DirectQuery, eliminating the need for data refreshes. However, Power BI’s semantic model connected via Direct Lake still offers refresh settings that can be toggled on or off, giving users more control over their data flow. In this article, Reza breaks down the functionality, helping users understand why this approach is referred to as Reframe and how it enhances flexibility in managing data without constant refreshes.
Author: Jared Westover
In this article, Jared Westover explores how to uncover missing indexes in SQL Server to significantly enhance performance. Indexing is often the hidden powerhouse behind query optimization, enabling performance improvements without altering the underlying code. Jared provides SQL Server scripts that can help boost performance through effective indexing strategies.
Author: Chris Webb
In this post, Chris Webb delves into the advanced relationship properties in Power BI Copilot, expanding on his recent work with Linguistic Schema and configuring Row Label and Key Column properties. Enabling his models for Q&A, Chris shares valuable insights and lessons learned along the way.
Author: Adam Saxton
We’ve previously discussed integrating Git with Azure DevOps, but now you can also connect GitHub with Microsoft Fabric! Once configured, the experience remains largely the same, as it’s still Git at its core. In this guide, Adam takes you through the setup process, showing you how to integrate GitHub with Microsoft Fabric and manage your repositories effectively. Whether you’re familiar with Git or new to Fabric, this walkthrough will help you navigate the integration with ease!
Need a community event warm-up before Dataminds Connect ’24 kicks off? Attend Europe’s first Fabric Community Conference, the ultimate Power BI, Fabric, SQL & AI learning event in Stockholm, Sweden from September 24 -27, 2024.
With 120 sessions, daily keynotes, 10 pre-conference workshops, an expo hall with community lounge, and “ask the expert” area, the conference offers a rich learning experience you don’t want to miss. This is a unique opportunity to meet the Microsoft teams building these products, customers betting their business on them, and partners at the forefront of deployment and adoption.
