Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
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
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