Sandeep PawarProfabric.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·687 readscolumn mapping
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·6.2K readsDP600
Sandeep PawarProfabric.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.0K readsDirectLake
Sandeep PawarProfabric.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·2.9K readsDirectLake
Sandeep PawarProfabric.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·14 likes·20.8K readsfabric
