Error when using Direct Discovery saying "Direct query returned empty result set"

[#1]

Hi All,

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:
DIRECT QUERY
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 ?

Below is the error I get…..

Thanks in advance.....