Sandeep Pawarfabric.guru·Dec 7, 2024Delta Lake Tables For Optimal Direct Lake Performance In Fabric Python NotebookIn my last blog, I showed how to use Polars in a Fabric Python notebook to read, write and transform data. What I did not cover was how to write a Delta Lake table in a Python notebook that’s optimal for DirectLake performance. All engines in Fabric ...Discuss·2 likes·1.2K readsmicrosoftfabricExcellent post, thank you for investing so much time in this! 3
Nalaka Wanniarachchibidiaries.com·Nov 17, 2024Fixed Identity and RLS in Microsoft Fabric Direct Lake Semantic Model : Perfect Pair 💏When dealing with massive amounts of data stored in modern platforms like Microsoft Fabric, one challenge always looms: How do you secure access while making the process seamless for users? Fixed Identity and Row-Level Security (RLS)—a duo that not o...DiscussFabricmicrosoftfabric
Sandeep Pawarfabric.guru·Nov 8, 2024Analyze Delta Tables In FabricI have been sitting on this code for a long time. I shared the first version in one of my blogs on Direct Lake last year. I have been making updates to it since then as needed. I waited for the lakehouse schema to become available and then forgot to ...Discuss·1.3K readsmicrosoftfabric
Kilian Baccaro Salinasdatagym.hashnode.dev·Oct 15, 2024Real-Time Hub: Tiempo real al alcance de todos (Vídeo)En esta sesión descubrirás cómo centralizar y simplificar el manejo de datos en tiempo real. Con el Real-Time Hub de Microsoft Fabric, puedes gestionar fácilmente flujos de datos en streaming desde múltiples orígenes en un solo lugar. También veremos...DiscussDirectLake
Sandeep Pawarfabric.guru·Oct 3, 2024Enabling Column Mapping For Spaces In Column Names In Delta TableOne of the annoying limitations of Direct Lake (rather of the SQL endpoint) was that you could not have spaces in table and column names in the delta table. It was supported in the delta table but the table was not query-able in the SQL endpoint whic...Discuss·995 readscolumn mapping
Sandeep Pawarfabric.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·6.7K readsDP600
Sandeep Pawarfabric.guru·Jul 10, 2023Pre-Warming The Direct Lake Dataset For Warm Cache Import-Like PerformanceWhen using the Direct Lake dataset, query performance primarily depends on whether the columns are cached in memory. If the dataset has not been framed, there will be nothing in the cache, meaning you are encountering a cold cache. In this state, the...Discuss·3.3K readsDirectLake
Sandeep Pawarfabric.guru·May 27, 2023Checking If Delta Table in Fabric is V-order OptimizedV-Order V-order is a write time optimization to the parquet file format. When the delta table is created using any of the Fabric engines (Dataflow Gen2, Spark notebooks, Pipelines, DWH), Delta tables are automatically are V-Order'd. This not only hel...Lamin Jobe and 1 other are discussing this2 people are discussing thisDiscuss·2 likes·3.1K readsDirectLake
Sandeep Pawarfabric.guru·May 24, 2023Power BI Direct Lake Mode : Frequently Asked QuestionsUpdated on Sept 09 2023 Microsoft announced an innovative dataset storage mode for Power BI called Direct Lake at Microsoft Build. It fundamentally changes how we create and consume BI solutions. It promises to provide the perfect balance between imp...JT and 8 others are discussing this9 people are discussing thisDiscuss·15 likes·22.1K readsfabric
