Forum Discussion

swapneelkale123's avatar
swapneelkale123
Regular Visitor
3 years ago

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 automatically, is it possible to implement in Power BI

Show and Tell

2 Replies

  • ppm1's avatar
    ppm1
    Solution Sage
    3 years ago

    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