UserInput for M Query where condition to pull data from data source

Hi All,

Looking for option where user needs to pass id in report filter which could be where clause in M query so that it could fetch and display only that data.

Have data in snowflake and its 5 million records. 9 users would be using report instead of pulling entire data set ad then apply filtering on it. Is it possible to pass member id in filter/somewhere so that datasource to snowflake can fetch records for that member dynamically.

Trying with M query but not able to get through. Any advise/suggestions please.

Regards,

Sandeep