Tag feed

#directlake

13 posts0 followers

Explore Hashnode

Alternatives

SPSandeep Pawarfabric.guruSep 1, 2025 · 2 min read

Direct Lake Incremental Framing Effect

I was writing a blog on Direct Lake incremental framing but my colleague Chris Webb beat me to it and just published an excellent blog. To summarize, with incremental framing, when a Direct Lake semantic model refreshes, it analyzes the Delta log to ...

0

SPSandeep Pawarfabric.guruJul 23, 2025 · 2 min read

How to Check If Your Power BI Report Uses the Default Semantic Model

Default semantic models will be going away : read the announcement here and the details. Starting August 8, 2025, Power BI default semantic models are no longer created automatically when a warehouse, lakehouse, or mirrored item is created. Note that...

0

SPSandeep Pawarfabric.guruFeb 10, 2025 · 2 min read

Migrate/Copy Semantic Model Across Workspaces Using Semantic Link Labs

Here is a quick script to copy a semantic model from one workspace to another in the same tenant, assuming you are contributor+ in both the workspaces. I tested this for a Direct Lake model but should work for any more other semantic model. This just...

2

RDJR

SPSandeep Pawarfabric.guruDec 7, 2024 · 11 min read

Delta Lake Tables For Optimal Direct Lake Performance In Fabric Python Notebook

In 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 ...

1

K

NWNalaka Wanniarachchibidiaries.comNov 17, 2024 · 7 min read

Fixed 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...

0

SPSandeep Pawarfabric.guruNov 8, 2024 · 9 min read

Analyze Delta Tables In Fabric

I 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 ...

0

M

SPSandeep Pawarfabric.guruOct 3, 2024 · 3 min read

Enabling Column Mapping For Spaces In Column Names In Delta Table

One 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...

0

SPSandeep Pawarfabric.guruNov 22, 2023 · 14 min read

Controlling Direct Lake Fallback Behavior

In 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...

2

RA

SPSandeep Pawarfabric.guruJul 10, 2023 · 7 min read

Pre-Warming The Direct Lake Dataset For Warm Cache Import-Like Performance

When 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...

0

SPSandeep Pawarfabric.guruMay 27, 2023 · 2 min read

Checking If Delta Table in Fabric is V-order Optimized

V-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...