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:

DAX Studio:

Tabular Editor:

Best Practice Rules:

Guidance Docs:


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #Performance #GuyInACube

[ryanfisher]

I just started using the performance analyzer and love it. I used it to show my team the difference a drop down filter vs a list makes.

[thedataguys]

As a Power Bi consultant these tips are indeed INSANE AMAZING! Nice work Adam. Going to work through these on some our models today!

[russhunter]

Good Stuff Just started working for a Company who uses Power Bi and your videos are going to be Very Helpful, Thank You

[gavclark]

Great as usual ! I learned something new too, i didn't know Performance Analyzer showed the DQ timings

[kirillperian]

Guys, this is awesome! Exactly what I was looking for! Especially for DQ enthusiasts out there... ;)

[yumyumhotsauce]

Thanks Adam! Another helpful video! You just gave me more work tomorrow.

[elrevesyelderecho]

Thanks. I will add to that list to check the Power Query ETL process.

[villeikonen]

Thanks a lot for this checklist and examples! Extremely useful!

[dbszepesi]

I definitely make sure to look at the model view. If its a big snowflakin' spaghetti mess we are going to be talking.

[Rajendran_PSG]

In Vertipaq analysis, we can choose the right encoding types Hash or Value based on the column data which will reduce the column size.
In Performance Analysis in Pbi file, Dax optimization by avoiding the call back data id. Thanks..

[Ahmad_Askar]

Any chance to do a video on how to estimate the time required for a BI project and what is the different pillars ... really appreciate your videos guys

[Zainab-ks]

Q: is there any way I can get a one on one troubleshooting session with you?

[larryglerum]

@Guysinacube I will look forward to how to troubleshoot errors. I get requests for Power BI dashboards that break, sometimes from the refresh breaking, but sometimes its a data issue. I look forward to your thoughts.

[dataguyin]

Indeed good tips, do you know when such features will be available to PowerBIDesktop RS version?
Thanks Guy In a Cube

[SalmanbinAthar]

A little zoom in would greatly enhance the visual quality, specially fir those using mobile phones.
Otherwise really helpful video.
Thanks

[ryanbartz]

#guyinacube where/what is the BPA Rules file? In the tabular editor section, it looked like you pulled that file from your local machine. Is that something that tabular editor or PBIX creates, or would I need to make that?

[Sarabjitsethi]

The first thing i used to tell me ..DONT EVER USE Select * From table. As it can create mess with unnecessary col's . So best practise is Select col1, col2, col3 from table...Anyway thanks for your video

[totvabe]

My problem when I look into the Performance Analyzer is not DAX query, is not Direct Query, …. my problem is "Other". What's that???

[sparshkapoor]

I am getting following error while uploading the excel dataset in power bi. can anybody help me out troubleshoot this. Unexpected error: The specified key is not a valid size for this algorithm.
Parameter name: key Key length: 40
Details:
The specified key is not a valid size for this algorithm.
Parameter name: key Key length: 40 ---> System.ArgumentException: The specified key is not a valid size for this algorithm.
Parameter name: key Key length: 40 ---> System.ArgumentException: The specified key is not a valid size for this algorithm.
Parameter name: key Key length: 40

[koutlaw]

I try to perform best practices from the beginning so I don't run into these issues