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..
@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.
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
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
#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?
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 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
Excellent Video, even after many years of this video, still one of the best.
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.
Good Stuff Just started working for a Company who uses Power Bi and your videos are going to be Very Helpful , Thank You
As a Power Bi consultant these tips are indeed INSANE AMAZING! Nice work Adam. Going to work through these on some our models today!
Great as usual ! I learned something new too, i didn't know Performance Analyzer showed the DQ timings
Thanks. I will add to that list to check the Power Query ETL process.
Thanks Adam! Another helpful video! You just gave me more work tomorrow.
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..
Guys, this is awesome! Exactly what I was looking for! Especially for DQ enthusiasts out there... ;)
Thanks a lot for this checklist and examples! Extremely useful!
@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.
I definitely make sure to look at the model view. If its a big snowflakin' spaghetti mess we are going to be talking.
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
Q: is there any way I can get a one on one troubleshooting session with you?
Indeed good tips, do you know when such features will be available to PowerBIDesktop RS version?
Thanks Guy In a Cube
A little zoom in would greatly enhance the visual quality, specially fir those using mobile phones.
Otherwise really helpful video.
Thanks
Pure gold!
Nice work!
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
#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?
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
SQL query in Power BI? Why at all?
@@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
Nice. Thanks
My problem when I look into the Performance Analyzer is not DAX query, is not Direct Query, …. my problem is "Other". What's that???
Too many visuals on one page
I try to perform best practices from the beginning so I don't run into these issues