Forum Discussion
Max Offline Dataset Size (GB) = total model size
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
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
- Anonymous1 year agoNot applicable
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.- joakimfenno1 year ago
Helper V
not yet, no reply to my last post