Question

You manage a semantic model published to a workspace backed by Premium capacity. The model has grown to 15 GB after several months of incremental refresh, and users report that the model occasionally fails to load because it exceeds the default in-memory limit. You must allow the model to grow beyond the standard size limit while keeping Import mode performance. What should you do first?

Accepted Answer

Enable the Large semantic model storage format setting for the model in workspace settings

Answer

Convert the semantic model to DirectQuery mode to remove the in-memory size limit

Answer

Increase the scheduled refresh frequency so partitions are compressed more often

Answer

Move the model to a Pro (shared) workspace to gain additional memory allocation