Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power Query and Snowflake integer datatype problem

I am importing date from a datamart from a Snowflake datamart in a Power BI dataset and facing a problem: The foreign keys in the Snowflake datamart are 18 digit hash keys. Power Query imports thes...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous  - please read the following Power BI data types in relationships - Does it matter? (maxwikstrom.se)
    It should be okay to convert to Text. 

    But here is the thing, I would look to change Snowflake.  IMHO the larger key values especially in low cardinality columns are just going to consume more Compute time and take up more storage. Therefore cost $$$ more money. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous  - please read the following Power BI data types in relationships - Does it matter? (maxwikstrom.se)
It should be okay to convert to Text. 

But here is the thing, I would look to change Snowflake.  IMHO the larger key values especially in low cardinality columns are just going to consume more Compute time and take up more storage. Therefore cost $$$ more money.