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.

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

[@rohtashgoyal]

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

[@gavclark66]

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

[@elrevesyelderecho]

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

[@yumyumhotsauce1]

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

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

[@dataguyin]

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

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

[@Zainab-ks]

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

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

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

[@andre-analytics]

Nice work!

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

[@Obizzy8]

Pure gold!

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

[@scramiro1]

Nice. Thanks

[@koutlaw30]

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