Excel at MBAS 2020 Highlights

%3CLINGO-SUB%20id%3D%22lingo-sub-1371683%22%20slang%3D%22en-US%22%3EExcel%20at%20MBAS%202020%20Highlights%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1371683%22%20slang%3D%22en-US%22%3E%3CP%3EExcel%20had%20a%20number%20of%20new%20%26amp%3B%20exciting%20updates%20at%20MBAS%202020%20-%20some%20key%20highlights%20below%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CEM%3EMBAS%20videos%3C%2FEM%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fmymbas.microsoft.com%2Fsessions%2F6c6643d1-ad39-46c2-a8ea-3bd5ae21a90b%3Fsource%3Dsessions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EEnterprise%20data%20in%20Microsoft%20Excel%3A%20New%20capabilities%20to%20help%20provide%20easy%20and%20secured%20access%20to%20centralized%20data%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fmymbas.microsoft.com%2Fsessions%2Fe19fedb9-97b7-41ea-83b8-d01f61ec6a77%3Fsource%3Dsessions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20accelerate%20a%20data%20culture%20with%20pervasive%20BI%20throughout%20your%20organization%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3E%3CU%3E%3CA%20href%3D%22https%3A%2F%2Fmymbas.microsoft.com%2Fsessions%2Ff90e8268-89fa-4f47-8f6f-6518db991821%3Fsource%3Dsessions%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EUnlock%20insights%3A%20Power%20BI%20vision%20and%20roadmap%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CEM%3EExcel%20%26amp%3B%20Power%20BI%20blogs%3C%2FEM%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fsimplifying-enterprise-data-discovery-and-analysis-in-microsoft%2Fba-p%2F1354160%22%20target%3D%22_blank%22%20rel%3D%22noopener%22%3ESimplifying%20enterprise%20data%20discovery%20and%20analysis%20in%20Microsoft%20Excel%3C%2FA%3E%3C%2FLI%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fdriving-a-data-culture-from-insight-to-action%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EDriving%20a%20data%20culture%3A%20from%20insight%20to%20action%3C%2FA%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20more%2C%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESubscribe%20to%20our%20%3CU%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlblog%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Blog%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3EJoin%20our%20%3CU%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Fxlcommunity%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EExcel%20Community%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3CLI%3EFollow%20us%20on%20social%20%3CU%3E%3CA%20href%3D%22https%3A%2F%2Ftwitter.com%2Fmsexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%40msexcel%3C%2FA%3E%3C%2FU%3E%20and%20%3CU%3E%3CA%20href%3D%22https%3A%2F%2Ffacebook.com%2Fmicrosoftexcel%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%2Fmicrosoftexcel%3C%2FA%3E%3C%2FU%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1371683%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EGeneral%20Comment%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377641%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20at%20MBAS%202020%20Highlights%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377641%22%20slang%3D%22en-US%22%3E*Wolfram%20Alpa%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1377639%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20at%20MBAS%202020%20Highlights%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377639%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%22%3CSPAN%3Enumber%20of%20new%20%26amp%3B%20exciting%22%20-%20seems%20a%20bit%20excessive%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ETwo%20would%20be%20more%20precise.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Ea)%20First%20something%20that%20we%20could%20do%20since%20July%202016%20(Power%20BI%20Publisher)%20now%20becoming%20a%20built%20in%20feature%20which%20is%20always%20welcome%20but%20hardly%20qualifies%20as%20new%20and%20exciting%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fanalyze-in-excel-from-power-bi-publisher-july-update%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fanalyze-in-excel-from-power-bi-publisher-july-update%2F%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eb)%20Second%2C%20additional%20Data%20types%20over%20and%20above%20Stock%20and%20Geography%20-%20Based%20on%20Power%20BI%20Datasets%2C%20PQ%20Data%20Types%20and%20Wolfram%20Alpha%20-%20which%20is%20brilliant%20!%20-%20but%20I%20hope%20doesn't%20get%20killed%20in%20Licensing%20issues%20(E5%20only%20would%20be%20greed%20winning%20over%20common%20sense)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKudos%20to%20the%20formula%20team%20for%20the%20setting%20a%20blazing%20pace%20in%20the%20past%2012%20months%20by%20adding%20LET%20(which%20got%20no%20mention%20in%20the%20video)%2C%20Dynamic%20Array%20Formulas%2C%20Speed%20improvements%20to%20MATCH%20%2F%20XMATCH%20and%20other%20Lookup%20functions.%20Couple%20of%20missed%20opportunities%20in%20XMATCH%20not%20having%20a%20If%20Not%20Found%20parameter%20like%20XLOOKUP%20and%20both%20not%20having%20a%20parameter%20to%20specify%20the%20Instance%20number%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20focus%20the%20rest%20of%20the%20year%20on%20removing%20the%20parity%20in%20the%20Mashup%26nbsp%3B%20and%20Vertipaq%20engines%20present%20in%20Excel%20and%20Power%20BI%20Desktop%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20hasten%20the%20introduction%20of%20Custom%20Visuals%20and%20make%20them%20work%20with%20Data%20in%20the%20Data%20model%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fexcel-announces-new-data-visualization-capabilities-with-power-bi-custom-visuals%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fblog%2Fexcel-announces-new-data-visualization-capabilities-with-power-bi-custom-visuals%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETragic%20to%20see%20that%20in%20a%203%20day%20event%20Excel%20gets%2020%20Mins.%3C%2FP%3E%3CP%3EAlso%20tragic%20to%20see%20the%20below%20from%20the%20Microsoft%20365%20Roadmap%20as%20of%20Today%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Annotation%202020-05-10%20145149.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190424i653D287CB0E0A0CF%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Annotation%202020-05-10%20145149.png%22%20alt%3D%22Annotation%202020-05-10%20145149.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDon't%20let%20the%20fear%20of%20Excel%20in%20the%20Power%20BI%20Team%20hamper%20the%20development%20of%20the%20worlds%20best%20spreadsheet%3C%2FP%3E%3CP%3EGet%20a%20Leadership%20team%20that%20has%20vision%20and%20courage%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20Regards%3C%2FP%3E%3CP%3ESam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Microsoft
1 Reply
Highlighted

@cuong "number of new & exciting" - seems a bit excessive

Two would be more precise.

 

a) First something that we could do since July 2016 (Power BI Publisher) now becoming a built in feature which is always welcome but hardly qualifies as new and exciting 

 

https://powerbi.microsoft.com/en-us/blog/analyze-in-excel-from-power-bi-publisher-july-update/

 

b) Second, additional Data types over and above Stock and Geography - Based on Power BI Datasets, PQ Data Types and Wolfram Alpha - which is brilliant ! - but I hope doesn't get killed in Licensing issues (E5 only would be greed winning over common sense)

 

Kudos to the formula team for the setting a blazing pace in the past 12 months by adding LET (which got no mention in the video), Dynamic Array Formulas, Speed improvements to MATCH / XMATCH and other Lookup functions. Couple of missed opportunities in XMATCH not having a If Not Found parameter like XLOOKUP and both not having a parameter to specify the Instance number

 

Please focus the rest of the year on removing the parity in the Mashup  and Vertipaq engines present in Excel and Power BI Desktop

 

Please hasten the introduction of Custom Visuals and make them work with Data in the Data model

 

https://powerbi.microsoft.com/en-us/blog/excel-announces-new-data-visualization-capabilities-with-po...

 

Tragic to see that in a 3 day event Excel gets 20 Mins.

Also tragic to see the below from the Microsoft 365 Roadmap as of Today

 

Annotation 2020-05-10 145149.png

 

Don't let the fear of Excel in the Power BI Team hamper the development of the worlds best spreadsheet

Get a Leadership team that has vision and courage

 

Best Regards

Sam