Forum Discussion
Subscription error when the table produced no results
Hi HazechanAB ,
Based on your description, this type of error typically occurs when the query or filter criteria for a data-driven subscription does not match any of the data that the subscription attempts to run with. Since your requirement is to only send emails if the value is greater than 0, if the matrix table does not have any such values, the subscription will not be able to generate results, resulting in the error you are seeing.
First, make sure that the query or filter conditions set for the subscription accurately reflect the data that is expected to trigger the subscription. Manually run a query against the semantic model to confirm that it returns results under the expected conditions.
Second, ensure that the semantic model is configured correctly and contains the expected data. You can also set up alternatives, including generic data matching, so that the conditions of the subscription don't disappear when the data is refreshed.
You can check out the following documents for more information on subscriptionsPower BI Subscription: Get Report Updates In Email - RADACAD
Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn
FAQs about Troubleshoot subscribing to dashboards and reports - Power BI | Microsoft LearnBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi HazechanAB ,
Based on your description, this type of error typically occurs when the query or filter criteria for a data-driven subscription does not match any of the data that the subscription attempts to run with. Since your requirement is to only send emails if the value is greater than 0, if the matrix table does not have any such values, the subscription will not be able to generate results, resulting in the error you are seeing.
First, make sure that the query or filter conditions set for the subscription accurately reflect the data that is expected to trigger the subscription. Manually run a query against the semantic model to confirm that it returns results under the expected conditions.
Second, ensure that the semantic model is configured correctly and contains the expected data. You can also set up alternatives, including generic data matching, so that the conditions of the subscription don't disappear when the data is refreshed.
You can check out the following documents for more information on subscriptions
Power BI Subscription: Get Report Updates In Email - RADACAD
Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn
FAQs about Troubleshoot subscribing to dashboards and reports - Power BI | Microsoft Learn
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
sorry but you clearly didn't read the OPs problem. it does exactly what he wants, only send a PDF when there are data to send. when there are no data, why should we send a pdf?
MS should add an option to prevent sending "empty" PDFs...
E.g.: i have a data source which only produces results when theres some exceptions in my data which i want the data team to fix. if there are no exceptions, then no report has to be sent. and thats not possible with the dynamic subscriptions, thats a major bummer imho.
