Prioritizing questions around optimization, performance, DAX, data modeling, processing, etc... 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to as many questions as we can. 👉 If you SPAM your question, [...]
Already optimized your data model and still having some performance issues in Power BI? Check out Michael Kovalsky's Report Analyzer tool to inspect your report. Michael Kovalsky: https://www.linkedin.com/in/michaelkovalsky/ Michael Kovalsky's blog: https://www.elegantbi.com/ Report Analyzer https://www.elegantbi.com/post/reportanalyzer
You should be reviewing performance of your Power BI Reports. This report from Smart Power BI helps you to visualize the results of Performance Analyzer. Let's check it out! Performance Analyzer Documentation: https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer ADVANCED POWER BI PERFORMANCE ANALYSER BY SMARTPOWERBI https://smartpowerbi.co.uk/2021/10/12/advanced-power-bi-performance-analyser-by-smartpowerbi/
We talk about optimizations a LOT! We pile onto a question posed by Chris Webb - Should you optimize for CPU in Power BI? We think the answer is YES! Let's explain... Chris Webb's Blog: https://blog.crossjoin.co.uk/2021/09/19/why-you-should-optimise-your-power-bi-premium-reports-and-refreshes-for-cpu-time-as-well-as-duration/ 3 signs it's time to OPTIMIZE your Power BI report https://www.youtube.com/watch?v=uKSkMDEGM2I
There are 3 signs that we look for to help tell us it's time to optimize your Power BI report. Adam looks at all 3 to help get you started in making your reports faster. Technique to improve Power BI report perf by reducing visuals https://www.youtube.com/watch?v=kkIXtvU1AiM Debugging a slow Power BI report with Phil Seamark [...]
We OPTIMIZE PERFORMANCE on a lot of models for Power BI. And, over the years, we start with the same first few things. Adam walks you through his steps. Performance Analyzer: https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer DAX Studio: https://daxstudio.org/ Tabular Editor: https://tabulareditor.com/ Best Practice Rules: https://powerbi.microsoft.com/blog/best-practice-rules-to-improve-your-models-performance-and-design-v1-1/ Guidance Docs: https://docs.microsoft.com/power-bi/guidance/ One Checkbox video: https://www.youtube.com/watch?v=RnDdDlozcdo
We've seen people comment that Power BI is SLOW. But, what they really mean is your report is slow. Patrick breaks things down to get you pointed in the right direction. Chris Hamill's Blog: https://alluringbi.com/2020/08/06/consolidating-report-elements-for-improved-performance/
Your Power BI report could be slow and not functional. Publishing to Power BI may also show you your ugly baby. Patrick has you covered with 5 things to do before publishing to get that cute baby! Power BI Tips: External tools (@PowerBITips) Splitting a Power BI (PBIX) File into a Dataset and Lean Report [...]
DAX Studio is an awesome tool! You can even use it to trace Power Pivot within Excel. Patrick shows you how!
You have a Power BI Performance problem. But, where do you start? How do you know what to focus on and what is noise? We break it down.