Direct Lake Semantic Model not showing latest data

[A454A]

Direct Lake Semantic Model not showing latest data:

I have refreshed the semantic model several times.

 I have turned off Cache ( it was by default - turned OFF)

Also cleared Cache from my PBI Report. (Although latest data i am checking by creating new report from semantic model itself (by pulling relavant fields), its not showing latest data.

Can you pls help

[v-tejrama · Accepted solution]

Hi @A454A ,

Your understanding is largely accurate, and your explanation reflects how this functions in Fabric. When using Direct Lake with a Warehouse, it still relies on the SQL analytics endpoint, which can introduce a brief delay before new data becomes visible. While this delay is typically minimal, it can vary based on workload, data volume, and update frequency.

You are also correct regarding semantic model refreshes. In Direct Lake mode, a refresh primarily updates metadata rather than performing a full data reload as Import mode does, so new data may not be immediately available if the backend has not yet synchronized. Clearing the report cache does not affect this, as the delay occurs before the semantic model receives the data.

The distinction you mentioned is important. When accessing Delta tables directly without the SQL endpoint, data generally appears much faster. The behavior you're observing is specific to scenarios involving Warehouses or SQL endpoints.

Thank you.

[v-tejrama]

Hi @A454A ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[v-tejrama]

Hi @A454A ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[InsightsByV]

+1 @tayloramy 

I have this similar query - 

I have also created a Power BI report with Directlake mode (for testing this mode) where data is coming from Mirrorring. Now I have also analysed that the data doesnt get refreshed instantly. What can be the reason for it? 

One thing I can think of is the latency but that doesnt seem to be an issue. Can someone guide? 

[tayloramy]

Hi @A454A,

Is this DIrectLake On OneLake, or DIrectLake on SQL? 

If it is DirectLake on SQL (created from the lakehouse UI) then it needs to wait for the SQL endpoint to refresh, which is not instant. There is a new activity in pipelines to force this refresh. 

[A454A]

Hi this is direct lake on Fabric Warehouse!