Performance Archives | Guy in a Cube

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 Performanceasaxton2021-05-20T06:43:55-05:00

Why is Power BI SLOW

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/

Why is Power BI SLOWpleblanc2021-03-31T07:34:25-05:00

STOP publishing your Power BI report until you do these 5 things!

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

STOP publishing your Power BI report until you do these 5 things!pleblanc2020-09-23T06:08:03-05:00

Trace Excel Power Pivot using DAX Studio

DAX Studio is an awesome tool! You can even use it to trace Power Pivot within Excel. Patrick shows you how!

Trace Excel Power Pivot using DAX Studiopleblanc2020-08-19T08:58:11-05:00

WHERE do you START with Power BI Performance???

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.

WHERE do you START with Power BI Performance???asaxton2020-06-18T07:39:02-05:00

Technique to improve Power BI report perf by reducing visuals

Having a lot of visuals in your Power BI Report can slow things down. Here's a technique you could employ to reduce visuals and improve performance. Download Sample

Technique to improve Power BI report perf by reducing visualsasaxton2020-05-14T08:22:27-05:00

6 things to get a little more out of your Power BI Desktop machine

Machine running slow with Power BI Desktop? One of these 6 things may help you out. Download Free PDF

6 things to get a little more out of your Power BI Desktop machineasaxton2020-02-12T20:35:05-05:00

How do you even use VertiPaq Analyzer with Power BI???

Not sure how to use VertiPaq Analyzer with Power BI to optimize your data model? Marco Russo joins Patrick to show you how!

How do you even use VertiPaq Analyzer with Power BI???pleblanc2019-11-13T10:01:13-05:00

Improve Power BI Report performance by using the filter pane

If you are using slicers in your Power BI report, moving them off to the filter pane could improve performance. Patrick shows you what this could look like based on a real customer story.

Improve Power BI Report performance by using the filter panepleblanc2019-04-24T10:05:55-05:00

Troubleshooting Gateway Performance

I walk through what I know about troubleshooting gateway performance. This can be useful for Power BI, PowerApps, Microsoft Flow or Azure Logic Apps. This includes two main areas. 1. Performance Counters 2. Tracking query duration within the gateway logs. Hopefully, this will help you dig into what the gateway is doing, and how to [...]

Troubleshooting Gateway Performanceasaxton2016-09-27T07:57:45-05:00