Snowflake datawarehouse - Import Mode - How to restrict data while importing with some conditions

[Anonymous]

Hi All,

This is the first time I am connecting to Snowflake DW.

We are trying to use import mode and fetch data from our Snowflake DW into PBI. 

Since we have huge amount of data, we can't import complete View/Table, so I want to restrict data while importing with some filters as per our requirement.

Unlike, SQL Database we don't see option to write SQL query to customize while importing. How do we do it ?

Can someone share a sample code and PBI file and show how to do it. 

Also, if there are any blogs/posts/videos online on same topic. Kindly share it over here.

Thanks in Advance.

[v-alq-msft]

Hi, @Anonymous 

You may refer to the following document to if they help.

Connect to a Snowflake computing warehouse 

Power BI enables connectivity to Snowflake 

Best Regards

Allan