Session

Power BI and Big Tables: Optimizing Performance with Hybrid Approaches

When working with large datasets in Power BI, the best performance typically comes from importing all the data into the model. However, there are times when this isn’t feasible - whether due to resource limitations or the sheer time required to refresh massive volumes of data. Enter DirectQuery mode, which connects directly to your data source without importing it - but this often results in sluggish performance and frustrated users.

Fortunately, Power BI offers more than just an "Import or DirectQuery" choice. By combining techniques like dual mode, hybrid tables, incremental refresh, pre-aggregated tables, and the emerging Direct Lake storage mode, you can strike a balance between data freshness and query performance.

In this session, Markus Ehrenmueller-Jensen will guide you through these advanced features, showing you how to implement hybrid solutions that give you the best of both worlds - fast query performance with up-to-date data.

What You'll Learn:
* The trade-offs between Import mode and DirectQuery
* How to use dual mode and hybrid tables for optimal performance
* Implementing incremental refresh and pre-aggregated tables
* Leveraging Direct Lake storage mode to handle large datasets
* Practical examples for real-world hybrid scenarios

Who Should Attend:
Power BI users, report developers, and data engineers who work with large datasets and want to optimize the performance and freshness of their Power BI reports.

Markus Ehrenmueller-Jensen

BI Architect

Vienna, Austria

Actions

Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.