Power BI allows for analyzing large amounts of data at high speed – which is needed to fuel interactive features in Power BI visual reports. The performance of Power BI is built on the Vertipaq engine – once imported, data is compressed and kept in memory. But this has its limits: what to do when the amount of data becomes too large for a regular import, or real-time analytics is needed? In these cases, you will need to resort to other ways of storing data.
In this session, we explore different storage modes in Power BI and how to use them. The best-known storage modes are Import and Direct Query. But it doesn’t end here. After this session, you will have a new appreciation of the power of the Power BI platform!