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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.