Power BI

New

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

Vote (51)

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)

Comments (6)

2f73e903 776c-47a6-9c67-7468d5edd927 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...

1c7a5439 757c-4c3d-8e8d-4812a0a86117 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

98d7fd5d 14cd-4f97-a714-a1c928e44f97 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.

c41a236b c50a-497a-b953-1854c07fbd32 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 :(

9a4b1927 7c55-48fd-a186-24777144380b on 05 Jul 2020 22:55:21

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

any update ?

c070429c 94a7-40a7-82ca-23e25efcfec3 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 ?