Forum Discussion
Executing SQL Server stored procedures with parameters from Power BI report
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 ...
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
yes direct query, thanks will check out that link
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
