Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.