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:
docs.microsoft.com/power-bi/c...
DAX Studio:
daxstudio.org/
Tabular Editor:
tabulareditor.com/
Best Practice Rules:
powerbi.microsoft.com/blog/be...
Guidance Docs:
docs.microsoft.com/power-bi/g...
One Checkbox video: • REDUCE Power BI datase...
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #Performance #GuyInACube

[@ryanfisher5835]

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.

[@thedataguys6203]

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

[@villeikonen8597]

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

[@yumyumhotsauce1]

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

[@russhunter7117]

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

[@gavclark66]

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... ;)

[@elrevesyelderecho]

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

[@andre-analytics]

Nice work!

[@Obizzy8]

Pure gold!

[@scramiro1]

Nice. Thanks

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

[@dataguyin]

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

[@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

[@dbszepesi]

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

[@larryglerum8003]

@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.

[@ryanbartz6874]

#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?

[@pakipower]

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

[@totvabe1]

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

[@jonathanjedrczak1753]

Too many visuals on one page

[@sparshkapoor8517]

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: Microsoft.Mashup.Evaluator.Interface.ErrorException: 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

[@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

[@avatorl_in_a_hammock]

SQL query in Power BI? Why at all?

[@aleksandrapetela4858]

@@avatorl_in_a_hammock native query with sql for selecting only the needed columns from table if your connection is direct query to a data source like dataverse which by default will import all the columns and make the model perform worse

[@koutlaw30]

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