Hello,
We are trying to build a user growth over time Power BI report via CDS.
For that, we will need to know when a contact has unsubscribed as that affected the count of contacts and which entity/table we can fetch that data from
We are aware that data is being captured in the Audit History that shows updates " do not allow bulk email" field. but we haven't been able to find that specific data in CDS.
Any insights from where can we fetch it from? or any other idea on how to count unsubscribed contacts?
Hi,
As I noticed that you have created a separate post, please refer to my reply in that post.
If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.
Best Regards,
Nya
Hi Nya,
We are able to find a column for that field with Option set: Allow, Does not allow. However, what we need is a date stamp of when that field was updated, so we know by when the contact unsubscribed.
Hi,
The name of the fields shown in Power BI is not the display name of them.
Please try to find the “donotbulkemail” field in Power BI.
If this helped you, I'd appreciate it if you'd mark this as a Verified Answer, which may in turn help others as well.
Best Regards,
Nya
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156