Power BI–Snowflake Hyperlink Query

On my Power BI dashboard I want a clickable element that launches a fresh SELECT statement in Snowflake and brings back one specific data set, not merely a filtered view of what is already cached. The connection between Power BI and Snowflake is already in place; what is missing is the mechanism that takes a clicked record (or any value you propose) and passes the right parameters to Snowflake, triggers the query, and then displays—or at least confirms—the returned data inside Power BI.

Please wire up the hyperlink, write any required DAX or M-query, and supply the Snowflake SQL you intend to run. If a gateway, stored procedure, or custom connector is the cleanest route, feel free to incorporate it as long as the final experience stays inside the dashboard environment.

Acceptance is based on:
• A working PBIX showing the hyperlink in the live dashboard view
• Evidence that a new query executes in Snowflake each time the link is clicked (query ID or timestamp)
• Returned data matches the specified SELECT logic
• Clear, step-by-step notes so I can reproduce the setup in other reports

Keep the solution lightweight, secure, and easy to maintain.