Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
swapneelkale123
Regular Visitor

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

2 REPLIES 2
ppm1
Solution Sage
Solution Sage

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

Microsoft Employee

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors