Performance issue: Planning sheet slow to load with 500 rows

Started by François Leblond · 1 year, 5 months ago · 3 replies · 2 views

François Leblond Participant

1 year, 5 months ago

My Planning sheet has about 500 account rows and 24 monthly columns. Initial load takes 15-20 seconds. Is this expected? Our semantic model is on F64 capacity in DirectLake mode. After load it's fine — just the initial rendering is painful.

3 Replies

Sort

Marcus Delacroix

Senior BI Architect · Peak Logistics Europe · 1 year, 5 months ago

In Direct Lake mode, the first query after a long idle period can be slow because the engine cold-starts. Subsequent loads will be much faster due to caching. If you're seeing 15-20s consistently, look at your DAX measure complexity first.

Up

0

Omar Hassan

Data Engineering Lead · InfraCore MENA · 1 year, 5 months ago

Also check the Capacity Metrics app while loading. If you see CU spikes on that first query, you may be triggering Direct Lake fallback to DirectQuery mode, which is significantly slower.

Up

0

Raj Subramaniam

Microsoft Fabric Consultant · CloudBridge Solutions · 1 year, 5 months ago

500 rows × 24 columns = 12,000 cells being calculated from the semantic model on first load. 15-20s is on the high side. Check whether your semantic model has heavy calculated measures that fire on the initial ALL() context — these can be expensive.

Up

0