How do I pass parameters to my SQL statement?

[Anonymous]

I am trying to use SQL stored proc in Power BI that takes country values (150+ countries) as parameters. So far,I was able to add the SQL stored proc and dynamically pass parameters using the filters. This approach uses native queries and it appears that i have to run the query against all the countries and later use the filter... Is there a way to avoid it? Can i run the query for 1 country and retrive the data for other countries as needed based on the filter selected? Thanks

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Here are some examples for your reference:

Execute SQL Server Stored Procedure With User Parameter In Power BI

parameters to SP or Sql query

Best regards,

Yuliana Gu

[Anonymous]

You can use the Parameter. In query Editor, you can see this option under Home Tab -> Manage paramters. The below link has the details of this.

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Thanks

Raj