Cracking Power BI Performance Tuning in a day!
2022TL; DR
Creating a Power BI report may look like an easy task, but there is a huge difference between the report that works and the report that works efficiently!
Session Details
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 workshop 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.
Feedback Link - https://sqlb.it/?6201
And, if you feel lost, I don't blame you - I've also been there!
That's why this workshop 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.
Feedback Link - https://sqlb.it/?6201
3 things you'll get out of this session
Speakers
Nikola Ilic's previous sessions
Breaking (in)visible walls - how helping others may help your personal growth!
After this session, you'll get nothing in terms of tech knowledge, but you will walk away with a good feeling in your soul, and understand why helping others also helps YOU in breaking many (in)visible walls!
Lessons learned from optimizing enterprise data models
What should you do when DirectQuery is the ONLY available option? How to reduce the data model size, while at the same time satisfying business requirements?
I'll share tips, tricks and workarounds learned and implemented in real-life scenarios on enterprise data models.
Ambush Assassins: Secret killers of your Power BI performance and how to deal with them
Tired of slow performing Power BI solutions? Sick of user complaints that their report takes forever to render? If you answered “YES” to either one of the questions above, join us for this session packed with best practices and tips to avoid secret (and non-secret) killers of the Power BI performance! No slides, no long story – it’s just YOU, Power BI, and us!
Azure Data Factory, Azure Logic Apps and Power BI for everyone
As above
From bank clerk to Microsoft MVP in 6 years - my journey!
Only 6 years ago, I was working as a regular bank clerk. Today, I'm a Microsoft Data Platform MVP and presenting at the biggest data conference in the world!