Forum Discussion
Snow Flake Connector - Power Query Editor
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.
4 Replies
Sunil_svk , refer if this blog can help
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
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
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
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.
