Forum Discussion
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 edit the table query to include this parameter but I'm not sure where to add this. Currently my table query looks like this:
=Sql.Database("DESKTOP-Name\SQLEXPRESS","X",[Query="SELECT * FROM dbo.Examples$"])
The name od the table is : dbo.Examples$
Columns in the table are: Country, Sum and People
HamidBee , One way I can think of is
=Sql.Database("DESKTOP-Name\SQLEXPRESS","X",[Query="SELECT * FROM dbo.Examples$ Where country = '" &Parameter1 & "' "])
also refer
2 Replies
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/
