Sandeep PawarProfabric.guru·3 hours agoTIL: FabricRestClient Supports Long Running OperationsI want to thank Michael Kovalsky for pointing out that FabricRestClient in Semantic Link supports (since v 0.7.5) Long Running Operation (LRO). 💡 LRO support allows the client to wait for the request to process without being blocked. Without LRO su...Discussmicrosoftfabric
Sandeep PawarProfabric.guru·Jul 24, 2024How to Attach a Default Lakehouse to a Notebook in FabricI wrote a blog post a while ago on mounting a lakehouse (or generally speaking a storage location) to all nodes in a Fabric spark notebook. This allows you to use the File API file path from the mounted lakehouse. Mounting a lakehouse using mssparkut...Discuss·1 like·307 readsmicrosoftfabric
Sandeep PawarProfabric.guru·Jul 19, 2024Calculating The Size of The Dataflow Gen2 Staging LakehousesMy friend Alex Powers (PM, Fabric CAT) wrote a blog post about cleaning the staging lakehouses generated by Dataflow Gen2. Before reading this blog, go ahead and read his blog first on the mechanics of it and the whys. Note that these are system gene...Discuss·364 readsmssparkutils
Parth Ladthenavigatedata.com·Jun 22, 2024Avoid Repetitive Steps in MS Fabric Dataflow Gen2 with Custom FunctionsWhile working with Dataflow Gen2 or Power BI, If you keep finding yourself needing to apply the same transformations to different queries or values, making a custom function in Power Query can save you loads of time. It's like using SQL functions to ...DiscussMicrosoft FabricMicrosoft
Sandeep PawarProfabric.guru·Jun 14, 2024Formatting All DAX Measures Using Semantic Link In FabricLast year I shared a blog post on formatting DAX expressions using DAX Formatter API (thanks to SQL BI). I extend the same idea in this blog to format all and save the formatted DAX in all measures in a semantic model using semantic link. 💡 WARNING...Discuss·2 likes·1.1K readssemantic-link
William Craygerlucidbi.co·Jun 9, 2024There's No Shortcut to Proper PlanningAbout a month ago, while working on the first iteration of the Fabric capacity monitoring report, I stumbled across a bit of an invisible fence. I posted a quick teaser with a screenshot on LinkedIn to see if anyone else could spot it: https://www.li...Discuss·1 like·440 readsmicrosoftfabric
Parth Ladthenavigatedata.com·Jun 3, 2024Power BI DAX : Context Explained in MinutesIn Power BI DAX, context is all about the environment that affects how a formula is calculated. It decides which subset of data is used for the calculation and lets you do dynamic analysis based on what users do. There are two main types of context i...DiscussPower BI DAXPowerBI
Nicolas PappasforTwo Viewstwoviews.hashnode.dev·Apr 30, 2024Fabric Mirroring: A Reflection of TimeMirror, mirror on the wall, who is the data replicator of them all? What is Fabric Mirroring, and why is it becoming significant in the data world now? I’d like to go through the history and talk about data mirroring and Change Data Capture being the...Discuss·5 likes·179 readsFabricMirroring
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·2.3K readsdataset optimization
Sandeep PawarProfabric.guru·Jan 29, 2024Using runMultiple To Orchastrate Notebook Execution in Microsoft FabricUsing runMultiple in MicrosoftFabric notebook isn't new. It was announced, I think, at MS Ignite in November 2023. I tested it and worked beautifully. But the Notebooks team has been quietly adding great features to it and I wanted to show some of th...Parth Lad and 1 other are discussing this2 people are discussing thisDiscuss·3.1K readsmicrosoftfabric