I am trying to pass a dynamic value$(vMonth) to the FROM clause of the DIRECT QUERY in the script. It works fine for the initially loaded month's data. But it’s throwing an error when I select a different month, which is passed through the variable $(vMonth) to the FROM clause to fetch the corresponding Months data. Here is the code where I am using the $(vMonth) in the FROM clause.
This is working only if I reload the app after a different month is selected. Is there a way to fetch the data corresponding to the value of $(vMonth) without reloading from the DIRECT QUERY ?
Below is the error I get…..
Thanks in advance.....