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 Jayee, I want to use Snowflake as a direct query data source and do not want to import the data.
If I try to change the datatype to 'Whole Number' in PowerQuery, then I can only import (rather than direct query) the table which defeats the objective of having a smaller in-memory dataset. Thanks for responding anyway.
Best regards, Oliver