Forum Discussion
How to parameterize Server & database name while using Snowflake database
Hi, I have created Power BI Report with the data connected to Snowflake database. Incase if i want to parametrize the Server name and database name using query parameters how do i do that? While us...
Hi, How to use this while passing from DEV to TEST and to PROD, can you please let me know....
create Parameter in Power Query with list of values, add DEV/TEST/PROD as values.
Then connect to snowflake using embedded connector and then change code in Power Query:
parameter name: ENV
old code "DATA_BASE_NAME_DEV"
new code with parameter "DATA_BASE_NAME_"&ENV