Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have a Power BI report on which we need to execute a stored procedure from. The stored procedure needs to take a dynamic parameter as well. Ideally we would like the user to be able to select the parameter via a slicer filter perhaps or similar, and then pass that as the parameter to the stored procedure that then executes and renders the resultant dataset.
Thank You.
Assuming you're connecting to the stored procedure via Direct Query?
There is a Power Bi preview feature which I think does what you need:
Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs
Looks like SQL Server isnt supported as a data source.
There are some considerations and limitations to consider when using dynamic M query parameters:
A single parameter cannot be bound to multiple fields nor vice-versa.
The feature is only supported for M based data sources. The following DirectQuery sources are not supported:
yes direct query, thanks will check out that link
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
18 | |
18 | |
13 | |
13 |
User | Count |
---|---|
36 | |
22 | |
21 | |
18 | |
12 |