Error when using Direct Discovery saying "Direct query returned empty result set"
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.
Table: DIRECTQUERY DIMENSION .
MEASURE ……… FROM schema.$(vMonth);
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 ?