Forum Discussion
How do I pass parameters to my SQL statement?
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
Hi Anonymous,
Here are some examples for your reference:
Execute SQL Server Stored Procedure With User Parameter In Power BI
Best regards,
Yuliana Gu
2 Replies
- AnonymousNot applicable
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
- v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Here are some examples for your reference:
Execute SQL Server Stored Procedure With User Parameter In Power BI
Best regards,
Yuliana Gu