Sandeep PawarProfabric.guru·Feb 29, 2024Calculating and Reducing Power BI Dataset Size Using Semantic LinkSemantic Link v0.6 is out and it has many new exciting additions to its growing list of list_* methods. Highlighted are some of the new methods. Install the latest version and check it out. Some of the existing methods such as list_columns() have an...Martin du Toit and 2 others are discussing this3 people are discussing thisDiscuss·1.7K readsdataset optimization
Sandeep PawarProfabric.guru·Jan 17, 2024One Line Code To Get A List Of Items From All The Fabric/Premium WorkspacesWhat the title says, thanks to the latest version (v0.5) of Semantic Link !pip install --upgrade semantic-link --q #upgrade to semantic-link v0.5 import sempy.fabric as fabric import pandas as pd df = pd.concat([fabric.list_items(workspace=ws) for...Discuss·1.2K readsmicrosoftfabric
Sandeep PawarProfabric.guru·Jan 11, 2024Cancelling Dataflow Gen2 RefreshUpdate : Mar 8, 2024 As of March 8, you can cancel the Fabric Dataflow Gen2 refresh in service using UI: Programmatically cancel the refresh: DFg2 can be resource intensive, and if the refresh takes longer than expected, it may consume a significant...Discuss·1 like·921 readssemantic-link
Sandeep PawarProfabric.guru·Dec 20, 2023Using FabricRestClient To Make Fabric REST API CallsAccessing Fabric REST endpoints in Fabric notebooks was already easy but it became easier and straightforward with semantic-link version 0.4.0. You can use the FabricRestClient class from sempy to set up a REST client and call the APIs. Authenticatio...Discuss·1 like·2.1K readsmicrosoft fabric
Sandeep PawarProfabric.guru·Dec 7, 2023Refreshing Individual Tables and Partitions With Semantic LinkSince version 0.4 Semantic Link there have been several methods to refresh individual tables and partitions in a semantic model. In this blog, I will show how to use the .refresh_dataset().execute_tmsl() and TOM to achieve granular refresh. Prerequis...Discuss·3 likes·3.3K readssemantic-link
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·3.9K readsDP600
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·1 like·2.3K readslakehouse
Sandeep PawarProfabric.guru·Nov 15, 2023Identifying Semantic Model Storage Mode in FabricWith the latest addition of Direct Lake as a storage mode in Power BI, the range of available storage modes continues to expand. If you look at the semantic models in the workspace, except for the Push Semantic Model, it's not possible to identify if...Discuss·872 readssemantic-link
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·2 likes·512 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.7K readssemantic-link