Sandeep PawarProfabric.guru·Nov 22, 2023Controlling Direct Lake Fallback BehaviorIn the flurry of announcements at MS Ignite, one significant feature related to Direct Lake got buried. You can now control the fallback behavior of the Direct Lake semantic model. Before we get into how you do that, a quick recap of what is fallback...Discuss·3 likes·511 readsDirectLake
Sandeep PawarProfabric.guru·Nov 20, 2023Visualizing JSON Structure In Fabric NotebookJSON is ubiquitous, particularly when working with APIs and logs. Its unstructured nature makes it highly flexible for handling anything from a simple array to a complex nested structure. However, this can also make it challenging for data analysis. ...Discuss·279 readsmicrosoft fabric
Sandeep PawarProfabric.guru·Nov 19, 2023Programmatically Creating, Managing Lakehouses in FabricAt MS Ignite, Microsoft unveiled a variety of new APIs designed for working with Fabric items, such as workspaces, Spark jobs, lakehouses, warehouses, ML items, and more. You can find detailed information about these APIs here. These APIs will be cri...Discuss·411 readslakehouse
Sandeep PawarProfabric.guru·Oct 30, 2023Formatting DAX Expression Returned By SemPy in FabricThere is an old Italian saying "If it's not formatted, it is not DAX" 😁 When you get the list of measures from SemPy, it's not formatted and is hard to read and understand. Thankfully, the SQLBI team has made the DAX parser and the formatter availab...Discuss·1 like·267 readsmicrosoft fabric
Sandeep PawarProfabric.guru·Oct 26, 2023Measure Maze: Visualizing Measure Dependencies Using Semantic Link & Network AnalysisIn my previous blog post, I introduced Semantic-Link, discussing its use cases and explained how it enables us to create solutions that were either not possible or not easily achievable before. In this blog post, I would like to present another power...Discuss·1.0K readssemantic-link
Sandeep PawarProfabric.guru·Oct 5, 2023Fabric Semantic Link and Use CasesFabric Semantic Link has finally been announced and is available for everyone to use. If you know me and have followed my blogs/presentations, you know that I am very passionate about data science, Power BI, notebooks and Python. If you ever meet wit...Discuss·3.0K readsmicrosoft fabric
Sandeep PawarProfabric.guru·Sep 23, 2023🚀Lightning Fast Copy In Fabric NotebookIf you are familiar with mssparkutils , you know that it is packed with utilities to perform common notebook tasks such as getting a list of files and folders, mount points, copying files, running notebooks etc. in Fabric. The Fabric notebook team ha...Discuss·3 likes·658 readsmicrosoft fabric
Sandeep PawarProfabric.guru·Aug 27, 2023BZ2, Linux Command Line and FabricApologies for the title that doesn't make any sense. Like many of you, I hadn't heard of bz2 until a few weeks ago. I've been doing experiments and performance tests on Fabric, which involved working with 300GB of data compressed using bz2 compressio...Discuss·143 readsmicrosoft fabric
Sandeep PawarProfabric.guru·Aug 27, 2023Creating Shortcut To KQL Table In Fabric LakehouseShortcuts in Microsoft Fabric are one of the best features that allow you to point to any location on OneLake from any engine without moving the original data. It just magically makes it appear virtually via embedded references within OneLake. The of...Discuss·213 readsKQL
Sandeep PawarProfabric.guru·Aug 9, 2023Calculating Folder Size In The LakehouseThis is more of a personal note to self than a blog post. When running various test scenarios, I calculate the size of the lakehouse by calculating the size of its folders (Files and Tables). The code I use is below. I'm sharing it here to save mysel...Discuss·190 readsmicrosoft fabric
