Forum Discussion
Pass Parameters from a SP in SQL into parameters created in Power BI(which can accept values)
In short, "Pass parameters within a stored procedure(In SQL say) so that the parameter values can be called/used in parameters made in Power BI(query) ?"
For eg: I have a SP in SQL which has 2 parameters (para1 and para2) which can take multiple/single value(s).
I call this SP in Power BI Query Editor and I can now see it in my data sets. This can be done.
What I want is, to create a parameter (say para) in Power BI which has its source as the SP in SQL such that if I pass a value into para (in Power BI), then data loaded from the SQL Server (my data source) into Power BI corresponds only to the value(s) I added.
Is this possible?
Thanks in advance!
[This may help in getting required data loaded only into Power BI, saving time.]
radz if i understood you correctly,
you need to create a query first to sql server that executes a sp with hard coded value for parameter. then once data loaded in power bi right click that query and click create a function and craeate. Once function is created you need to right click -> Advanced Editor and replace code to parameterise hard coded values that will be supplied to sp parameter. hope that make sense.
Hi @ankitpitara
Yes it made sense and helped me. Thanks.
But instead of creating a function, I directly replaced code in the Query created by going to Advanced Editor, to parameterize the hard coded values.
This was done by adding Power Bi Parameters by concatenating them using &.
Thanks for your help.
8 Replies
radz if i understood you correctly,
you need to create a query first to sql server that executes a sp with hard coded value for parameter. then once data loaded in power bi right click that query and click create a function and craeate. Once function is created you need to right click -> Advanced Editor and replace code to parameterise hard coded values that will be supplied to sp parameter. hope that make sense.
Hi @ankitpitara
Yes it made sense and helped me. Thanks.
But instead of creating a function, I directly replaced code in the Query created by going to Advanced Editor, to parameterize the hard coded values.
This was done by adding Power Bi Parameters by concatenating them using &.
Thanks for your help.
