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.
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.
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).
Fantastic walk thru and thank you for all the time you’ve invested in helping us DAX mortals to be more like you!!
Awesome!
There have been cases where i would love having a second opinion on optimisation, this seems apt!
Great content SQLBI... you're awesome....
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.
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.
Can it do calculation groups and also review precedence?
Calculation groups are coming soon. How would you consider precedence, though? Precedence is about semantics, not performance.
If you have comments in your dax code, does that get sent too? Do we need to strip out our own personal comments?
Comments are part of the measure, you can use the obfuscation to remove any reference - see th-cam.com/video/UTCnjzgsz4A/w-d-xo.html
so it doesn't work with SSAS models?
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).