Forum Discussion
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...
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.
Thanks Anonymous Interesting reply and link. I will test this too.
(And yes, assuming whole numbers are the best perfomance-wise because of it is broadly seen as best practice :-))