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://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
- Import Mode : Also, I'm able to execute a stored Procedure but cannot pass end user input parameters here
If we have to create a table , it is going to generate several million rows. Hence, we want to dynamically get user input and fetch only a subset of this. Please suggest.
Thanks for your help in advance!