Forum Discussion
Parameter not updating
I created a paramters startdate, enddate and intervention added query1 let
SQLSource = (StartDate as date, EndDate as date, ParmIntervention as text) =>
let
...
What made you choose the "Query" option for suggested values ?
I thought this was the only option. Please let me know if there is any other option.
Thank you
It's not a bad option but it's not the only one. There are many ways to do this in Power Query. You could use text parameters, or reference tables from other sources etc.
I tried converting the Stored Procedure to view and its very difficult.
The stored procedure is very complex, with parameter present in where clause as well as joining the table.
If I start constructing the SP in powerbi it's going to be very hard.