Executing SQL Server stored procedures with parameters from Power BI report

[alongi]

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.

[bcdobbs]

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

[alongi]

Looks like SQL Server isnt supported as a data source.

Considerations and limitations

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:

  • T-SQL based data sources: SQL Server, Azure SQL Database, Synapse SQL pools (such as Azure Synapse Analytics (formerly SQL Data Warehouse)), and Synapse SQL OnDemand pools
  • Live connect data sources: Azure Analysis Services, SQL Server Analysis Services, Power BI Datasets

[alongi]

yes direct query, thanks will check out that link