Forum Discussion

alongi's avatar
alongi
Frequent Visitor
4 years ago

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 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.

Need Help

3 Replies

    • alongi's avatar
      alongi
      Frequent Visitor
      4 years ago

      yes direct query, thanks will check out that link

    • alongi's avatar
      alongi
      Frequent Visitor
      4 years ago

      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