fbpx

When optimizing Power BI don’t forgot about CPU

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

When optimizing Power BI don’t forgot about CPU2021-10-14T07:48:47-05:00

🔴 Power BI tips from the Pros – LIVE w/ Alberto Ferrari (October 9, 2021) (Member Chat 2nd Half)

Join us live as we answer your questions about Power BI with special guest Alberto Ferrari from SQLBI! 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 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: [...]

🔴 Power BI tips from the Pros – LIVE w/ Alberto Ferrari (October 9, 2021) (Member Chat 2nd Half)2021-10-05T05:50:26-05:00

How to show 5 minute intervals in Power BI?

Another question from the comments... MrTavelBlog wanted to know how to show 5 minute intervals in Power BI. Patrick accepts the challenge and shows you how! Power BI date table: create using DAX https://www.youtube.com/watch?v=gyvhM5eiT0U Working with time in Power BI Desktop https://www.youtube.com/watch?v=8DFih8ccMV0 Create Buckets or Groups with Power Query in Power BI https://www.youtube.com/watch?v=D1LO8syugMA

How to show 5 minute intervals in Power BI?2021-10-06T06:33:06-05:00

Finding the lowest value and highlighting in DAX | Power BI

Sometimes you want to highlight the lowest value in a Power BI visual. First you need to find it! Then you can highlight it. What if you want to ANIMATE it? Patrick shows you how to do just that! ALLSELECTED() article: https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/

Finding the lowest value and highlighting in DAX | Power BI2021-09-29T07:09:46-05:00

DAX! Uggg – Where do you start? | Power BI

Not a coder? Don't understand DAX syntax? DAX can be intimidating and difficult to learn. Frustrating even! Learning DAX can make Power BI very rewarding. Adam has some resources to get you started in your journey. Beginning the journey MS Learn: User DAX in Power BI Desktop (Free) SQLBI: Introduction to Data Modeling for Power [...]

DAX! Uggg – Where do you start? | Power BI2021-09-23T06:21:25-05:00

Unboxing Tabular Editor 3 | Reaction Video

It's here! Patrick does a reaction video when using Tabular Editor 3 for the first time with Power BI. To say he's excited is an understatement. Watch him take the wrapping off of Tabular Editor. Tabular Editor: https://tabulareditor.com/

Unboxing Tabular Editor 3 | Reaction Video2021-06-16T05:27:10-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

A TWIST on dynamically filtering visuals by a slicer in Power BI

Here's a twist on dynamically filtering visuals by a slicer in Power BI! You can't use a measure directly in a slicer, so here's a way to get a similar experience and maintain usability of your reports. Scott Sewell: https://twitter.com/scottsewell BI Elite Video: https://www.youtube.com/watch?v=AZAL-QPn5Zc

A TWIST on dynamically filtering visuals by a slicer in Power BI2021-05-19T05:51:02-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
Go to Top