Forum Discussion
Handling Parameterised Stored Procedures while migrating SSRS to Fabric
Hi max_mrc,
In Power BI/Fabric, parameterized stored procedures cannot be executed dynamically at report runtime as they can in SSRS, because queries are executed during refresh in Import mode. The closest alternative is using Dynamic M Query Parameters, which bind slicer values to parameters and pass them into the source query. This method requires DirectQuery mode, enabling queries to run based on user actions. However, stored procedures are not fully supported for dynamic query folding, so you might need to move logic into views or parameterized queries. Combining DirectQuery with Dynamic M parameters offers the most similar behavior to SSRS parameters.
DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
Thank you.
Hello max_mrc
You can invoke stored procedures with parameters using a pipeline activity. The stored procedure can easily write to a Lakehouse or a Warehouse table that drives the Power BI report. Microsoft Fabric pipelines can be executed on specific events, not just on a schedule or manually.
The stored procedure parameters in the activity allows you to supply dynamic parameters too!