Bind parameters with drill through functionality on Snowflake Direct query tables (summary & detail)

Hi Amty63 , I think dynamic M parameters might not support this please check these options as workarounds

• Create pre-aggregated views in Snowflake for the Summary table and fetch detailed data dynamically through queries.
• Configure relationships in Power BI to use Summary table filters for dynamically loading Detail data.
• Consider using Paginated Reports for better handling of large datasets with minimal data load.
• Use a stored procedure or parameterized query in Snowflake to fetch detail rows based on selected Summary rows and call it through Power BI.
  If this post helped please do give a kudos and accept this as a solution 
  Thanks In Advance