Pass user input parameters from report page to SQL stored procedure

Hi guys, I am currently trying to build a very dynamic report for my end users, and it would require something like this: I create a page with one-or-more input field (slicer or something lik...

Need Help

v-kelly-msft
6 years ago
Hi Astorre72 ，

Yes, create query parameters then go to data source setting>select the parameter you need and put your exec queries in Sql statement to get your SQL stored procedure,see below pics:

Here is a reference about how to use query parameter.

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters#:~:text=To%20create%20or%20access%20Query,bring%20up%20the%20Parameters%20dialog.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Forum Discussion

Pass user input parameters from report page to SQL stored procedure

Related content

Stored Procedure to Manipulate Tables

Power BI Report Builder: Cannot access report parameters inside Power Query (M language)

Passing PowerBI Parameter To A Stored Procedure

Data compression Procedure

Passing Report Builder Parameters to a Stored Procedure Through a Power Query Data SourceMy challeng