Vertipaq Encoding

[awhiteway]

Hello there,

I recently started digging deeper into performance of PowerBI files and have been digging into Vertipaq analyzer / the DAX studio version of it. I'm noticing almost every single one of my integer / decimal columns are being encoded as hash which is blowing up the storage of the data.

I saw another thread recommend Tabular Editor - I'm not seeing a property to set an encoding hint and the code they provided is not working either. The internet seems largely void of resources for this - anyone else dug this far into this?

Thank you!

[v-easonf-msft]

Hi ， @awhiteway 

These articles may help:

improve-analysis-services-tabular-2017-processing-with-encoding-hints

inside-vertipaq 

Vertipaq-Engine-VALUE-vs-HASH 

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@awhiteway , refer if this can help

https://www.microsoftpressstore.com/articles/article.aspx?p=2449192&seqNum=3

[lbendlin]

@marcorusso has a series of videos on that topic (deep dive into DAX Studio) at https://daxstudio.org/documentation/videos/