Parameterizing Snowflake connection details-Server,Compute WH, Database name using Query Parameters

[Anonymous]

Hi,

I have created Power BI Report with the data connected to Snowflake database. Incase if i want to parametrize the Server name,computing warehouse and database name using query parameters how do i do that?  While using SQL Server, Get data-> SQL Server, we get option New parameter, where we define the Servername, computing wh and database name parameters. But while connecting to Snowflake from Get data option I am unable to parameterize. 

Under Files& Options, Power Query, I have checked the Allow parameter option.

Kindly need help in understanding how Query parameters can be used for setting Server /DB name when conencted to Snowflake database.

Appreciate if anyone can guide on this!

[v-luwang-msft]

Hi @Anonymous ，

The following vedio tells about specifying Parameters for Data Source,refer it and check if it is helpful:

https://www.youtube.com/watch?v=1UkDaiRGShM

Best Regards

Lucien 

[fjellfisk]

This works ok with sql connections, but the parameters option for the snowflake connection isn't available! This should be an easy fix for the Power bi devolopers to add!🤪