fbpx

Understanding the TIMELINE in DAX Studio

We brought Marco in to help explain the TIMELINE update within DAX Studio. This can help you understand performance a bit deeper when optimizing your DAX and models. This is one to watch! DAX Studio https://daxstudio.org Marco Russo https://twitter.com/marcorus https://www.linkedin.com/in/sqlbi/ https://sqlbi.com Optimizing DAX Video Course https://www.sqlbi.com/p/optimizing-dax-video-course/

Understanding the TIMELINE in DAX Studio2023-06-14T08:12:46-05:00

How to handle Aggregation tables with Averages in Power BI

Using Aggregation Tables in Power BI? Average calculations not working because they aren't hitting the agg? Patrick explains why this is happening and how you can correct it to get the expected result.

How to handle Aggregation tables with Averages in Power BI2023-01-04T07:15:36-05:00

The Tale of Two Caches

Want to optimize performance in Power BI? Of course, you do! In order to do that, you need to understand the two caches that are at play and how they affect your optimization efforts. Marco Russo helps explain! DAX Studio 3 https://daxstudio.org Connect with SQLBI: Website: https://sqlbi.com YouTube: https://www.youtube.com/sqlbi Marco Russo: https://twitter.com/marcorus Alberto Ferrari: https://twitter.com/FerrariAlberto

The Tale of Two Caches2022-08-31T08:08:49-05:00

What tool do you use to optimize your Power BI dataset?

Need some help optimizing your Power BI Dataset but don't want to hand over your Power BI Desktop file? Patrick shows you some tools to get information to help with optimizing assistance! These are tools we use EVERYDAY! DAX Studio https://daxstudio.org/ Bravo for Power BI https://bravo.bi/ Tabular Editor 3 https://tabulareditor.com/

What tool do you use to optimize your Power BI dataset?2022-06-15T07:54:00-05:00

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???

Using Aggregations in Power BI? Have some DISTINCTCOUNT in your measures? Wondering why the queries are slow and not hitting the aggs? Patrick shows you what is going on! Get ready for some DAX fusion! DAX Fusion: https://dax.tips/2019/08/05/dax-fusion/ Aggregations Documentation: https://docs.microsoft.com/power-bi/transform-model/aggregations-advanced

Why isn’t my Agg hitting when using DISTINCTCOUNT in Power BI???2022-05-11T06:40:26-05:00

Case of the SLOW Power BI report: Hierarchies and RLS

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/

Case of the SLOW Power BI report: Hierarchies and RLS2021-09-02T05:11:29-05:00

3 signs it’s time to OPTIMIZE your Power BI report

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 [...]

3 signs it’s time to OPTIMIZE your Power BI report2021-08-19T05:29:19-05:00

Tracing your DAX queries in Power BI

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/

Tracing your DAX queries in Power BI2021-06-10T06:01:59-05:00

My CHECKLIST for troubleshooting Power BI Performance

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

My CHECKLIST for troubleshooting Power BI Performance2021-05-20T06:43:55-05:00
Go to Top