Power BI : Passing parameters to SQL query

Job ID: 32883863

Budget: $10 – $30 USD

Need help passing parameters to SQL query in Power BI

This is the query
Declare @FromDate date
Set @FromDate='2022-01-01'
Declare @ToDate Datetime2
Set @ToDate='2022-02-09'
;
select @FromDate = min(S0.Docdate) from dbo.OINM S0 where S0.Docdate >=@FromDate
select @ToDate = max(S1.Docdate) from dbo.OINM s1 where S1.Docdate <=@ToDate

Select a.Warehouse end as Warehouse
, a.Itemcode, max(a.Dscription) as ItemName From XXXX
Related categories: Power BI