Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
HazechanAB
Frequent Visitor

Subscription error when the table produced no results

Dear All experts,

 

I want to create a subscription which ONLY send emails to me when any value >0 is found in a matrix table.

The reason why i use subscription but not alert is because data activator alerts dont have the PDF attached in the email.

Any way, I tested the subscription and the email saids:

 

There was an error with your subscription "XXX" and it could not be delivered

DataDrivenSubscriptionPreProcessingError

Semantic Model XXX produced no results. Check your subscription and filters for any issues.

 

 

 

Please let me know if you have any solution. Thank you all in advance.

1 ACCEPTED SOLUTION
v-heq-msft
Community Support
Community Support

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

View solution in original post

1 REPLY 1
v-heq-msft
Community Support
Community Support

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.