Forum Discussion

adelm's avatar
adelm
Frequent Visitor
6 years ago

Parameter in query

Hi   I am using Power BI to pull data from SQL Server, I would like to use parameters to change the company name in the query . Below is an example for a simple query, my wish is to replace the XX...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Check

https://www.biinsight.com/power-bi-desktop-query-parameters-part2-dynamic-data-masking-and-query-parameters/

https://channel9.msdn.com/Blogs/MVP-Azure/Pass-parameter-to-SQL-Queries-statement-using-Power-BI

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

adelm's avatar
adelm
Frequent Visitor
6 years ago

Thank you for your answer, this is not what I am looing for, with your solution I need to switch between each parameter manually.

What I am looking for is more like a loop into company names listed in param list to refresh the data