Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
rvp_ordix
Helper I
Helper I

DirectLake Semantic Model failes to load due to supposed Disk Size Limit

We have a Semantic Model in our PowerBI-Service that connects to our Lakehouse in the same workspace via DirectLake. When I tried to open the data model today, though, the following error message is displayed:

rvp_ordix_0-1738657789613.png

Reports that connect to the model also fail to load, though the SQL Endpoint the model is building on works fine. The blacked out Database ID is the ID of the model itself, not the underlying lakehouse.

The claim that this model would "exceed the maximum size limit on disk" is very confusing, since according to the MS Learn Direct-Lake-page even an F2 capacity has a Size On Disk Limit of 10GB for DirectLake models. We use an F16, which means that our limit should be 20GB. 

Max Memory is the only limit we may plausibly be reaching, but even. Neither Size On Disk nor Max Memory will block you from working with a DirectLake Model if exceeded. According to the documentation they'd simply impact performance.

 

Usually I'd have tried to remove tables from the model to get it back under that "limit" and figure the cause out afterwards, but I can't even do that with the data model inaccessible. 

 

What is happening, and how can I fix this?

1 ACCEPTED SOLUTION

I've "solved" it now. Scaling the Capacity of that workspace up to F64 temporarily allowed me to access the data model again, and I've removed a few of the tables that were large but not very important. Afterwards it worked on F16 again. 

 

That being said, I still don't really understand, what exactly the problem was. To your points:

  • There was no Service Issue
  • I have attempted a regular refresh, though that failed. How can I manually clear a model's cache? There is no option for that in the settings.
  • The problem was independent of any report, and there is no transformation in a DirectLake Model, so there were no queries to be deactivated.
  • How do I check the connection? Both model and Lakehouse were in the same Fabric Workspace. I can't really affect anything there.

 

View solution in original post

2 REPLIES 2
Akash_Varuna
Helper V
Helper V

Hi @rvp_ordix  , I think it is like a resource issue rather than exceeding size limits Please do try out these steps

 

  • Check for Service Issues: Look for any ongoing issues on Power BI or Azure status pages.
  • Clear Cache/Force Refresh: Try clearing the cache or refreshing the model to resolve metadata issues.
  • Reduce Query Load: Temporarily disable heavy queries to ease the load.
  • Check Connections: Ensure the connection between the DirectLake model and lakehouse is stable.
    If this post helped please do give a kudos and accept this as a solution 
    Thanks In Advance

I've "solved" it now. Scaling the Capacity of that workspace up to F64 temporarily allowed me to access the data model again, and I've removed a few of the tables that were large but not very important. Afterwards it worked on F16 again. 

 

That being said, I still don't really understand, what exactly the problem was. To your points:

  • There was no Service Issue
  • I have attempted a regular refresh, though that failed. How can I manually clear a model's cache? There is no option for that in the settings.
  • The problem was independent of any report, and there is no transformation in a DirectLake Model, so there were no queries to be deactivated.
  • How do I check the connection? Both model and Lakehouse were in the same Fabric Workspace. I can't really affect anything there.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.