Regarding Power BI Connectivity to Snowflake

[swapneelkale123]

Hi all, I have a requirement where I need to connect to Snowflake by passing just one parameter eg. DEV/TEST/PROD and all the server name, warehouse, role and DB values should be populated automatically, is it possible to implement in Power BI

[ppm1]

Yes. You could import a table (e.g., Excel) or use Enter Data to bring in a small table that has a column with Dev/Test/Prod and other columns for the other values for each. You can then filter that for the entered parameter value and use the values from that row in other queries.

Pat

[swapneelkale123]

Thanks Pat, Will try it out and revert on the same.