Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

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!

Need Help
Show and Tell
Tutorial Requests

2 Replies

    • fjellfisk's avatar
      fjellfisk
      Frequent Visitor
      2 years ago

      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!🤪