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

[Anonymous]

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

[amitchandak]

@Anonymous , In Direct query Dynamic M parameters can help https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters