Need to pass the variables dynamically into sql script as a source into Power BI Desktop

Hi Team,

This is the simple exampel to understood

Declare @Employee varchar(max)

Set @Employee = 'Filter Value from Slicer Visual from Power BI'

Select top 10
EmployeeID,EmployeeAddress from Employee where EmployeeName=@Employee

If we select Employee = 'Dhoni' from Power BI Slicer Visual , the sql source script should as follows

Declare @Employee varchar(max)

Set @Employee = 'Dhoni'

Select top 10
EmployeeID,EmployeeAddress from Employee where EmployeeName='Dhoni'

If we pass multiple values like Employee = Dhoni,Kohli then the sql query should be as follows 

Declare @Employee varchar(max)

Set @Employee = 'Dhoni','Kohli'

Select top 10
EmployeeID,EmployeeAddress from Employee where EmployeeName in ('Dhoni','Kohli')

Please do the needful . Thank You.

Hi Anonymous ,

Please take a look at the following link to see if it helps, and hopefully some other expert in Power BI will be able to solve it.

How-do-I-pass-parameters-to-my-SQL-statement 

Hope it helps,

Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.