Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow for passing parameters (like date) via slicer like offered by other tools

Vote (3) Share
nirvana_moksh's profile image

nirvana_moksh on 01 Nov 2018 02:02:31

Anyone who works with SQL databases knows stored procedures and stored procedures with parameters is so very common. That being said PBI should have the functionality of allowing a property function to define these parameters which can be selected by the users (via a Slicer maybe) which then in return retrieves the necessary results by running that stored proc from the db. This is already available in almost every other reporting tool but PBI is lagging behind despite it being so so so amazing.

Comments (2)
nirvana_moksh's profile image Profile Picture

on 30 Oct 2020 20:52:54

RE: Allow for passing parameters (like date) via slicer like offered by other tools

Anyone who works with SQL databases knows stored procedures and stored procedures with parameters is so very common. That being said PBI should have the functionality of allowing a property function to define these parameters which can be selected by the users (via a Slicer maybe) which then in return retrieves the necessary results by running that stored proc from the db. This is already available in almost every other reporting tool but PBI is lagging behind despite it being so so so amazing.

nirvana_moksh's profile image Profile Picture

Pratik Thanki on 05 Jul 2020 23:40:13

RE: Allow for passing parameters (like date) via slicer like offered by other tools

Refer to this as the main Idea for this functionality to avoid duplication:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20367082-passing-parameters-to-power-bi-through-stored-proc

Merged Idea (1)