cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
martinrowe Regular Visitor
Regular Visitor

Vertipaq Column encoding - HASH v VALUE

Is there anyway to understand why vertipaq chooses to encode a column in HASH v VALUE? I have 2 tables where 2 column values are sequential primary keys in MySQL database, one is also a foreign key in the other table;

 

Transaction_History_ID - Primary key in Transaction_History
Subscription_ID - Primary Key in Applications (also foreign key in Transaction_History)

 

When the model was first created the values were encoded as VALUE

 

Vertipaq Output 2.jpg

 

I then amended the model to remove Gateway_Transaction_ID from the Transaction_History table and refreshed. Now after this refresh it has decided to encode the same 2 columns in HASH rather than VALUE and as a result the dictionary size has balooned.

 

Vertipaq Output.jpg

 

Why would it do this?

 

To me the obvious choice would be to set this as VALUE given the nature of the source column. I have tried to use Tabular Editor to set the encoding hint as VALUE however it doesnt seem to act on this and has decided that HASH is now required.

 

The below 2 articles I have looked at, but I dont think they provide an insight as to why this would happen when between the 2 refreshes when the data model is essentially the same bar removal of 2 columns.

 

https://community.powerbi.com/t5/Desktop/Vertipaq-Engine-VALUE-vs-HASH/m-p/690874#M333145

https://www.mssqltips.com/sqlservertip/5150/improve-analysis-services-tabular-2017-processing-with-e...

 

1 REPLY 1
Community Support Team
Community Support Team

Re: Vertipaq Column encoding - HASH v VALUE

Hi @martinrowe ,

 

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", to get further help.

 

Best Regards,

Amy

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors