William Craygerlucidbi.co·Apr 11, 2024How To Reduce Data Integration Costs By 98%One of the amazing things about Microsoft Fabric is the number of options you have for moving data. For example, you can use Dataflow Gen2, Pipelines, Notebooks, or any combination of the three. However, with all the options available, it can also ma...Discuss·2.4K readsdata-engineering
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.6K 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·890 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·1.9K readsmicrosoft fabric
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.8K readsDP600
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·1 like·836 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·1 like·2.1K 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·2 likes·502 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