Good morning,
I'm starting now in Power BI and I'm trying to make two sql queries swap parameters.
At first query I have a query sql returns the project code and the name of it.
In the second query I have the following proc (exec [dbo]. [pr_PBIControledecotas] 'project name').
What I need to do is where 'Project Name' is written to be replaced with the name I selected in the previous query (query 1).
Is it possible to do this in power BI?
Thank you in advance for your help.