Enabling parameter in Desktop

[Anonymous]

Hi All,

I have a situation where I have a query where I have declared the start date and end date in the query, when I run the complete query on Power BI it gives me the output but I want to change the filters i.e start date and end date on Power BI end only  and also wish to have the same as filters or if possible wish to use them as slicer.

Please let me know how to go about the same.

[Anonymous]

Hi @Anonymous ,

It's not supported to pass the slicer value to SQL statement.

Check if query parameters in Power BI Desktop suits your needs.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters 

https://reevessmith.wordpress.com/2014/08/19/power-query-and-stored-procedures-with-parameters/ 

Best Regards,

Jay

[amitchandak]

@Anonymous , you can use Power query parameters. But I doubt you can use a slicer on that. If is direct query, you can think of dynamic M parameters