Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreWe've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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:
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?
Solved! Go to 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:
Hi @rvp_ordix , I think it is like a resource issue rather than exceeding size limits Please do try out these steps
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:
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 18 | |
| 17 | |
| 14 |