Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dataset date as parameter

Hi   Im trying to add a parameter for narrowing a a dataset.   = Sql.Database("xxxserver.database.windows.net", "DB", [Query="Declare @DateLoadFromMonthMinus1 as Date; Declare @DateLoadFromYearM...
Need Help
lbendlin's avatar
lbendlin
Super User
5 years ago

how are you defining the parameter value? is it coming from the result of another query, or is it static?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I set the parameter on the dataset in the service to "@DateLoadFromYearMinus10". The scheduled refresh succeeds but its not using the expected parameter. Its seem like it using the other defined parameter from the example which is the default parameter