Forum Discussion
Avoid to send scheduled report with no data
Hello, I have a paginated report published on Premium Workspace on Power BI Service. We have scheduled some reports filtered by one parameter. If for a parameter, there is no data, can I avoid t...
skiwii
Advocate I
Advocate IThis is an inherit problem with its SSRS underpinnings. The only way I've avoided this in the past is to throw an SQL error so the subscription fails. To do this, insert your data into a temp table, and if the row count =0 raise an error.
Ugly but it works.