Skip to main content

    Power BI

    Needs Votes

    Input parameters in power bi that then retrieve data from a SP in SQL

    Vote (68) Share
    's profile image

    on 22 Jul 2016 15:48:41

    Parameters can be created in Power BI but they have to be input from Query Editor. Calling a SP from SQL which has a parameter that can take multiple values, and then these values to be called from a "parameter in Power BI" is a basic requirement.

    Comments (6)
    's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:46:39

    RE: Input parameters in power bi that then retrieve data from a SP in SQL

    Would love an update on this. The most basic reporting programs have been able to deal with bind variables in Oracle since the beginning of time.

    Looks like a feature intentionally left out...

    's profile image Profile Picture

    Thomas Wiegelman on 05 Jul 2020 23:41:14

    RE: Input parameters in power bi that then retrieve data from a SP in SQL

    I support 'Power BI Online Query Parameters' - what do you think? https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13820190-power-bi-online-query-parameters

    's profile image Profile Picture

    Charles on 05 Jul 2020 23:14:08

    RE: Input parameters in power bi that then retrieve data from a SP in SQL

    My database is large and I need to limit the load to a date range. Can't find a way to pass parameters to my table query.

    's profile image Profile Picture

    Juramirez on 05 Jul 2020 23:05:45

    RE: Input parameters in power bi that then retrieve data from a SP in SQL

    Any update? Can't find something to solve this :(

    's profile image Profile Picture

    rik on 05 Jul 2020 22:55:21

    RE: Input parameters in power bi that then retrieve data from a SP in SQL

    any update ?

    's profile image Profile Picture

    Gowtham Veera Raghavan on 05 Jul 2020 22:52:55

    RE: Input parameters in power bi that then retrieve data from a SP in SQL

    any update on this ?