Max Offline Dataset Size (GB) = total model size

[joakimfenno]

I have a semantic model in fabric and have hit the limit for Max Offline Dataset Size (GB)

Is Max size of a semantic model = Max Offline Dataset Size (GB)?

In that case its 3GB for F8.

How is this related to Max Direct Lake model size on OneLake (GB)1, 4 (which is 10 GB for F8)?

[joakimfenno]

Does it mean that if I set the model to direkt lake only mode max offline dataset size will not apply?

[rajendraongole1]

Yes, when you set your Power BI Fabric model to Direct Lake only mode, the Max Offline Dataset Size (GB) limit does not apply. This is because Direct Lake mode operates differently from traditional import or DirectQuery models.

Ensure that your workspace supports Direct Lake (currently in Microsoft Fabric).

Direct Lake works optimally for scenarios where the data resides in Delta Lake format in OneLake.

[rajendraongole1]

Hi @joakimfenno - 

Yes, the maximum size of a semantic model in Fabric aligns with the "Max Offline Dataset Size (GB)" limit for the SKU being used. For instance, on the F8 SKU, this limit is 3 GB. This limit applies when a semantic model is queried in an offline mode (e.g., when all data resides in memory for optimized querying).

On the other hand, the "Max Direct Lake model size on OneLake (GB)" refers to the maximum size a semantic model can have while utilizing the Direct Lake mode, where data is queried directly from Delta tables stored in OneLake without fully loading it into memory. For the F8 SKU, this limit is 10 GB. This mode allows querying larger datasets than the offline mode, as it retrieves data dynamically from OneLake.

Reference links:

Solved: Size limit per Semantic model - Microsoft Fabric Community

Solved: Dataset size limit vs Capacity Memory - Microsoft Fabric Community

[joakimfenno]

it does not make sense to me. I have set DIrekt Lake Only but still receive the error for max offline dataset size. I will read the links that you privided

[Anonymous]

Hi @joakimfenno 

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster?

Thank you very much for your kind cooperation.

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[joakimfenno]

not yet, no reply to my last post