cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Fernando_Morata New Member
New Member

Parameter to switch between source queries.

In my Dash Board I have two queries, one query that returns the code and the name of the project and the other is a proc. Is it possible to get the name of the selected project to pass as parameter in proc to query in sql database?

My idea would be as if it were a .net form with a combobox where after selecting the project, the system would show the data for the selected project.

The instruction of the second query looks like this:

exec [dbo]. [pr_PBIControlled] @ProjectName (The @ProjectName is the name of the project that I selected in the previous query).

 

Thank you for your help.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Parameter to switch between source queries.

HI, @Fernando_Morata

You may try to use Parameters in Power BI Edit Queries.

This is the tutorial for you to refer to

reference:https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

 

 

Best Regards,
Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Parameter to switch between source queries.

HI, @Fernando_Morata

You may try to use Parameters in Power BI Edit Queries.

This is the tutorial for you to refer to

reference:https://www.mssqltips.com/sqlservertip/4475/using-parameters-in-power-bi/

 

 

Best Regards,
Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.