Using a parent/child hierarchy? Check out how we diagnose performance when using some of the PATH DAX functions in Power BI and also how to make this report faster! PATHCONTAINS Reference: https://dax.guide/pathcontains/
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 [...]
Learn how you can trace your DAX queries when trying to troubleshoot or optimize Power BI reports and datasets. There are a few options and Adam walks you through them. DAX Studio: https://daxstudio.org/ SQL Server Management Studio: https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15 Visualize Your Refresh: https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
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 mentioned them multiple times but now to bring them all together. These are the TOOLS you need to take Power BI to the NEXT LEVEL! Tools we use every day! Performance Analyzer: https://docs.microsoft.com/power-bi/create-reports/desktop-performance-analyzer External tools in Power BI Desktop https://docs.microsoft.com/power-bi/transform-model/desktop-external-tools DAX Studio: https://daxstudio.org/ Tabular Editor: https://tabulareditor.com/ Best Practice Rules: https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/ ALM Toolkit: http://alm-toolkit.com/ Guidance [...]
Learn how to get your DAX measures in working order, using DAX Studio, before putting them in your Power BI report. Patrick walks you through it! SQLBI article: https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/ Hiding Future Dates video: https://www.youtube.com/watch?v=VXd1wl-5vKI
We know that DAX, in Power BI, can be intimidating. We've been there. Patrick shows you how you can learn DAX using what you have available today and TAME the beast that is DAX! DAX.Guide: https://dax.guide DAX Studio: https://daxstudio.org/ DAX Patterns: https://daxpatterns.com Microsoft Learn: https://docs.microsoft.com/learn/paths/dax-power-bi/ Download Sample
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup203 Patrick's tech video: https://guyinacu.be/paginated2021 Adam's tech video: https://guyinacu.be/whatispowerbi 🔴 Live Replay: https://guyinacu.be/live037 📢 Become a member: https://guyinacu.be/membership Sources DAX Studio 2.14 Release (@darrengosbell) ALM Toolkit in Power BI (@HowToPowerBI) Why is DAX so difficult to learn? (@CurbalEN) Exploring new [...]
You may be able to write a DAX expression, but what about an actual DAX query? DAX queries can help you validate data and fine tune your DAX expressions used for Power BI. Patrick shows you how!
Too many rows? How is that possible? Patrick looks at a case where a customer hit an error of too many rows coming back from a DAX statement in Power BI.