Power BI Performance - 7 Deadly Sins! | Nikola Ilic

Speaker: Nikola Ilic, MVP
Start Date: Thu, Jan 27th 2022 · 07:00 PM EEST
Language: English
Location: Online (link visible for attendees)

===============================================

Description:

Congratulations!
You've built your shiny fancy Power BI report and your charts look terrific. But, your data refresh takes forever...Or, your report is utterly slow when interacting with visuals...
You switch to DirectQuery mode to make things better, just to discover that the report performance sucks even more...

And, if you feel lost, I don't blame you - I've also been there!

That's why this session is for you: we will examine potential bottlenecks in your Power BI report - starting with defining the best practices for data model size optimization, understanding the importance of query folding feature, all the way to identifying culprits for your slow report rendering.
We will wrap it up with learning when and why (not) to use DirectQuery mode, and how to apply improvements on the data source side to make things faster in the Power BI.

===============================================
Speakers:
Nikola Ilic, MVP

I'm making music from the data!
PowerBI and SQLServer addict, Microsoft Data Platform MVP, Pluralsight Author, blogger, speaker...
Working as a Manager Analytics for Avanade.
Interested in everything related to data - always eager to extract valuable info from raw data in the most effective way.
Multi-year experience working with (predominantly) Microsoft Data Platform (SQL Server, SSAS, SSIS, SSRS, and Power BI).
Father of 2 and true football (and Barca) fan!

https://data-mozart.com/