Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Update from January 2023 to September 2023, now data-driven subscriptions not emailing!

Hi, We have updated our Power BI Report Server from January 2023 to September 2023, email delivery data-driven subscriptions (pageinated reports) were working, but not now!   After the update, repo...
"Data-driven email"
Subscription
  • Anonymous's avatar
    Anonymous
    2 years ago

    In the meantime we have found out that the problem is caused by the fields in the dataset that contain the "NULL" value. For instance, if the field [CC] is used in the data-driven subscription, but you don't have always an email to send to, and you leave NULL in the [CC] column of the dataset, then the email will not work. If you set the [CC] column to empty (delete the NULL), then the email will work again.

v-alipat's avatar
v-alipat
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

Hi all, 

Anonymous , Anonymous , 

 

Thank you for reporting the issue! 🙏

 

We found the fix and it will be available with the next releases of PBIRS, as well as SSRS19 and 22. 

 

Unfortunately, at the moment I don't have a precise ETA for the next release or QFE to share. 

Until it's done, as a workaround you may edit your datasets to set empty strings instead of NULLs, it will help.

 

Sorry about the inconvenience. 

 

Thanks,

Alexandra