Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @Anonymous,
Here are some examples for your reference:
Execute SQL Server Stored Procedure With User Parameter In Power BI
Best regards,
Yuliana Gu
Hi @Anonymous,
Here are some examples for your reference:
Execute SQL Server Stored Procedure With User Parameter In Power BI
Best regards,
Yuliana Gu
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
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |