DAX Optimizer overview - Unplugged #56

A complete tour of DAX Optimizer, the tool to improve your DAX code's performance, scalability, and readability.
Try the free samples at www.daxoptimizer.com
Disclaimer of a potential conflict of interest: Marco Russo is one of the authors of DAX Optimizer and a founder of Tabular Tools, the company that produces and distributes it.
Read more about the "unplugged" format: www.sqlbi.com/blog/marco/2021...
#unplugged
Disclaimer of a potential conflict of interest: Marco Russo is one of the authors of DAX Optimizer and a founder of Tabular Tools, the company that produces and distributes it.

[@daustonian9331]

Fantastic walk thru and thank you for all the time you’ve invested in helping us DAX mortals to be more like you!!

[@umangkhanna8087]

Awesome!
There have been cases where i would love having a second opinion on optimisation, this seems apt!

[@moisesgonga1302]

Great content SQLBI... you're awesome....

[@stevefox7469]

Thanks for showing how to inspect what information is inside the VPAX file. We were evaluating DAX Optimiser earlier in the week, and were concerned that we couldn't see what metadata was actually inside the VPAX. Hoping to get this tool OKed by our security team, and run it over some of our problematic models.

[@stevefox7469]

Our problem is, our corproate security team have an issue with connection strings in vpax metadata (noteably in the M-Code). Which is probably fair enough. So we look forward to the anonymization feature refered to in the Havens consulting walkthough of DAX Optimizer.

[@zxccxz164]

so it doesn't work with SSAS models?

[@SQLBI]

It works with SSAS models as well! For practical reasons we show a Power BI model in the video, but you can absolutely work also with models published on-premises (SSAS) and on Azure (AAS).