Trigger stored procedure with dynamic parameter from dashboard input

Hi joelsennhauser ,

I think you can take advantage of the Power BI integration with Dynamic M Query Parameters.
First you can create parameters in Power Query, for dynamic M query parameters you can check this document: Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

After defining the parameters, bind them to the e.g. slicer on the Power BI report. This binding allows end users to dynamically select parameter values directly from the dashboard. The selected values can then be passed to the stored procedure.
To call a stored procedure with dynamically selected parameters, you need to reference those parameters in the M query.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.