Empty columns when importing from snowflake

[Anonymous]

I am trying to import data from a snowflake database table. When the data is imported 4 of the 10 columns are imported as completely empty ( all null values), however the column headers are correct.

I have also noticed that the columns which are empty are all obtained from a calculated function in SQL such as AVG or MIN. I don't know if this is related or not, but the table in snowflake shows the data correctly.

When I download the data from snowflake to csv and then import into snowflake, the data works just fine.

[amitchandak · Accepted solution]

@Anonymous, I have used aggregated queries from snowflake and got the correct data. Open power query and check if there is an error related to data type. That can be an issue