Forum Discussion

Regular Visitor

4 years ago

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:...

Need Help

Tutorial Requests

Anonymous
4 years ago
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
Chris Webb's BI Blog: TSQL Table-Valued Functions And Dynamic M Parameters In Power BI DirectQuery Chris Webb's BI Blog (crossjoin.co.uk)

Anonymous

Not applicable

4 years ago

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

Chris Webb's BI Blog: TSQL Table-Valued Functions And Dynamic M Parameters In Power BI DirectQuery Chris Webb's BI Blog (crossjoin.co.uk)

Forum Discussion

Dynamic Stored Procedure Call based on user input parameters

Related content

Stored Procedure to Manipulate Tables

Dynamic subcription parameter not saving

Sum dynamic parameter fields multiple selected parameter

Help Needed: Passing Dynamic Parameters to SQL Stored Procedure in Power BI

dynamic parameter