Forum Discussion
Solved
Where do I add a parameter into my table query?
I have imported a table using SQL query into Power BI. I then created a parameter in Power Query with the name as 'Country' and set the Current Value as 'England'. I understand that I am meant to edi...
HamidBee , One way I can think of is
=Sql.Database("DESKTOP-Name\SQLEXPRESS","X",[Query="SELECT * FROM dbo.Examples$ Where country = '" &Parameter1 & "' "])
also refer
HamidBee , One way I can think of is
=Sql.Database("DESKTOP-Name\SQLEXPRESS","X",[Query="SELECT * FROM dbo.Examples$ Where country = '" &Parameter1 & "' "])
also refer
Thank you for the solution Amit. In case anyone else would like to look into this further I did find a useful resource:
https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/
