Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
alongi
Frequent Visitor

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.

3 REPLIES 3
bcdobbs
Community Champion
Community Champion

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



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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

yes direct query, thanks will check out that link

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.