fbpx

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

Tools to take Power BI to the NEXT LEVEL

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

Tools to take Power BI to the NEXT LEVEL2021-05-13T06:18:59-05:00

Test your Power BI DAX measures in DAX Studio

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

Test your Power BI DAX measures in DAX Studio2021-05-12T06:26:53-05:00

TAME the the beast that is DAX in Power BI (aka how to learn DAX)

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

TAME the the beast that is DAX in Power BI (aka how to learn DAX)2021-03-10T07:36:18-05:00

All about DAX and data modeling in Power BI… (Roundup | Jan 18, 2021)

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

All about DAX and data modeling in Power BI… (Roundup | Jan 18, 2021)2021-01-18T11:01:42-05:00

Power BI Case: Too many rows from a DAX Statement

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.

Power BI Case: Too many rows from a DAX Statement2020-11-25T10:04:30-05:00

Why you should use DAX Studio with Power BI

Are you using DAX Studio with Power BI? Patrick shows you why you should consider using it when working with DAX for Power BI! DAX Studio: https://www.sqlbi.com/tools/dax-studio/

Why you should use DAX Studio with Power BI2020-11-04T08:17:11-05:00

REPLAY Power BI tips from the Pros – LIVE w/ SQLBI (Oct 17, 2020)

Replay of live stream with Marco Russo and Alberto Ferrari from SQL BI. 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 Questions answered in stream Q: Is it possible to show 2 lines on the line chart for 2 different months? If yes how do u ensure [...]

REPLAY Power BI tips from the Pros – LIVE w/ SQLBI (Oct 17, 2020)2020-10-18T06:32:36-05:00
Go to Top