Forum Discussion
Regarding Power BI Connectivity to Snowflake
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 automatica...
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
Thanks Pat, Will try it out and revert on the same.
