Forum Discussion
Bind parameters with drill through functionality on Snowflake Direct query tables (summary & detail)
Hello Team,
Is it possible to drill through using bind paramater on Snowflake direct query tables (sumary & detail)
Summary - row count is 4K
Detail table - row count is 900K
I am trying but it is not working I think it is not feasible as per below microsoft documentation
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
However, I am looking for a solution or workaround if possible.
I don't want to import full tables data because of cost effective solution.
Kindly help me if it is possible.
2 Replies
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
Akash_Varuna
I would like to know the workaround that can work not copilot my question.
please reply if you know anything about it.
