On a number of occasions I have come across the error below (or another error something similar to it) when attempting to run a Webi report:
According to this message the query has no data but I came to notice that this is not always true and it may still be possible to retrieve data from this report. The test is simple: adding an “End date” to the query.
Refresh the report and entered a date (preferably the todays date) in the “Entered End date (YYYYMMDD)” prompt:
Here is the outcome. As you could see we no longer get the error.