Snow Flake Connector - Power Query Editor

[Sunil_svk]

Hi,

am extracting the data using snowflake connector. below is the code.

i would like to fetch data by passing few parameters. Ex: extaction of data for a specific year i.e., 2020 (year is a paramter).

let
    Source = Snowflake.Databases("XXX.snowflakecomputing.com", "&Warehouse&", [CreateNavigationProperties=null, ConnectionTimeout=null, CommandTimeout=null]),
    PRT_DEV_Database = Source{[Name="PRT_DEV",Kind="Database"]}[Data],
    DWH_Schema = PRT_DEV_Database{[Name="DWH",Kind="Schema"]}[Data],
    DIM_MONTH_Table = DWH_Schema{[Name="DIM_MONTH",Kind="Table"]}[Data]
in
    DIM_MONTH_Table

Suggest the modifications in code.

[v-yingjl]

Hi @Sunil_svk ,

It has been listed in the future feature:

Snowflake connector enhancements for Power Query Desktop 

The Snowflake connector will add support for custom roles and native queries. This will allow users to have much greater specificity in returning the desired data.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Sunil_svk , refer if this blog can help

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

[Sunil_svk]

Hi Amit

Thanks for the quick response.

Passing parameters is available for SQL Server.

Our datasource is Snowflake and we cannot pass parameters from UI. Could you pls suggest if there is any workaround in Advance editor to filter the required parameterized records

[amitchandak]

@Sunil_svk , I checked this list. Snowflake is not there. I doubt you can pass.

https://docs.microsoft.com/en-us/power-query/native-database-query