Forum Discussion
Anonymous
2 years agoNot applicable
PowerBI connect to Snowflake as data source filter
I have a question regarding the data connection.
Let's say there is a field called date in my source table and I would like to use it as a filter in my dashboard
I am query the data using SQL with Snowflake. Is there a way I snowflake can read my filter settings (date) in the powerbi front end so that powerbi doesn't have to query the whole table every time (because it would be very big)
2 Replies
- amitchandak
Super User
Anonymous , If you are using the direct query, the filter should fold to the source. You can try Dynamic M parameters
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
- AnonymousNot applicable
Any example on how to use M parameter in junction with snowflake?