Forum Discussion
Snowflake connector direct query not returning integer surrogate key only decimal/float
I am in the process of porting a large 100% imported (from postgres) PowerBI model to use Snowflake as the direct query source for some of the larger tables while continuing to import other dimension...
Hi oliversc
I'm having the same problem. It seems to be caused by the fact that Snowflake treats all integer values as number(38,0). So, when this is imported into PBI, it is seen as a decimal type.
As you are using Drirect query in PBI model view you can change the datatype to wholenumber for that column it will not impact much and in dataset it will treat as wholenumber itself.
If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!