Why Your Direct Lake Report Broke at 1.5 Billion Rows — and How to Fix It
A Power BI team hit a silent fallback to DirectQuery when their 1.5 billion‑row Direct Lake report exceeded the memory limits of their Fabric capacity. By trimming Delta row groups, adjusting framing strategies and resizing the SKU, they restored Direct Lake performance and avoided a launch‑day crash. The lessons expose hidden operational constraints most users miss.