My CHECKLIST for troubleshooting Power BI Performance

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

[@rohtashgoyal]

Excellent Video, even after many years of this video, still one of the best.

[@russhunter7117]

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

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

[@gavclark66]

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

[@yumyumhotsauce1]

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.

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

[@villeikonen8597]

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

[@kirillperian]

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

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

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

[@dataguyin]

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

[@dbszepesi]

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

[@Zainab-ks]

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

[@Obizzy8]

Pure gold!

[@andre-analytics]

Nice work!

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

[@scramiro1]

Nice. Thanks

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

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

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

[@koutlaw30]

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