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
Is this solution still viable? I've followed the steps, and I can get a DirectQuery to a stored procedure that takes no parameters. As soon as I switch to a parameterized sproc (same functionality, just includes the param in the select along with the rest of the data), the preview shows appropriate data, but a warning indicates I must change all my sources to Import mode.