Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

    Passing Parameters to Power BI through Stored Procedure

    Vote (541) Share
    Ankit's profile image

    Ankit on 02 Aug 2017 10:26:30

    There Should be Provision of passing the Parameter to the report like we do in SSRS Reports. There should be any method to execute Stored Procedure by passing the Parameters

    Comments (56)
    Ankit's profile image Profile Picture

    Dan Blake on 06 Jul 2020 00:11:22

    RE: Passing Parameters to Power BI through Stored Procedure

    I am surprised this is not available - quickly hit the limits of what power BI can do against large record sets and considering migrating dashboards to SSRS.

    Ankit's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:10:20

    RE: Passing Parameters to Power BI through Stored Procedure

    YES NEED THIS

    Ankit's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:09:50

    RE: Passing Parameters to Power BI through Stored Procedure

    Yes, we really need this. Is it on the roadmap?

    Ankit's profile image Profile Picture

    Frustrated developer on 06 Jul 2020 00:09:49

    RE: Passing Parameters to Power BI through Stored Procedure

    This is absolutely needed. With the increasing amount of data in the databases, we need to be able to filter data at the source dynamically. You build one stored procedure, one report, and pass dynamic parameters through URL to get what you want. It's so simple, it should have been there from the start.

    Ankit's profile image Profile Picture

    Charles on 06 Jul 2020 00:05:45

    RE: Passing Parameters to Power BI through Stored Procedure

    And please allow parameter types other than Text to work in the Query editor, it is very frustrating that the queries fail when you try to pass a date or INT value, the only solution currently is to rewrite the SPs...

    Ankit's profile image Profile Picture

    Aidan on 06 Jul 2020 00:05:35

    RE: Passing Parameters to Power BI through Stored Procedure

    Please!

    Ankit's profile image Profile Picture

    PC PC on 06 Jul 2020 00:04:49

    RE: Passing Parameters to Power BI through Stored Procedure

    Can't believe this isn't a feature since it has been in SSRS for years.

    Ankit's profile image Profile Picture

    Gnathan on 06 Jul 2020 00:04:02

    RE: Passing Parameters to Power BI through Stored Procedure

    this is badly needed as power bi we should be moving forward and not back wards.. hi dev team i know you guys try to bring features every month. not sure why this critical basic requirement is still not in power BI as this has been raised since 2015!! in this forum ..

    Also multiple result set to return from SP to handle via power bi .. SSRS legacy has all this but not in power BI!!.. dev team could you seriously look into this.


    Thanks
    nathan

    Ankit's profile image Profile Picture

    niels skovgaard on 05 Jul 2020 23:59:37

    RE: Passing Parameters to Power BI through Stored Procedure

    fix the damn thing already....been waiting for this for over a year now ......!?!?!?!?
    We have a lot of customers on standby on this feature!

    Ankit's profile image Profile Picture

    Lorie obal on 05 Jul 2020 23:57:10

    RE: Passing Parameters to Power BI through Stored Procedure

    This is badly needed for handling reports with large volumes of data. I've had to decrease report efficiency just to use Power BI.

    Merged Idea (1)