Forum Discussion
Solved
Dynamic Stored Procedure Call based on user input parameters
I want to be able to execute a stored procedure based on the input parameters selected by end user. DirectQuery Mode : I'm able to use dynamic M query parameters for SQL queries using - https:...
Hi DeepaS - the first option is possible using the correct syntax. Here are couple of blogs to consider.
Power BI Dynamic M Query Parameters Reloaded – Prologika
Anonymous
We are having function1 to feed data for Page1 and function2 to feed data for Page2. When we drill through from Page1 to Page2, the transient filters are displaying correct values but the data is not filtered in Page2 based on Page1 filters ( transient filters). Please suggest.
Thanks,
Deepa