News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Daily data snapshot of...

Customer experience | Sales, Customer Insights,...

Suggested answer

Daily data snapshot of Dynamics 365 online tables (accounts, contacts, leads, custom entities)

(0) Share

Report

Report

Posted on by KVa

293

Which technology would you recommend to create daily data snapshots of the Dynamics 365 tables? What I want to achieve is to build a report which allows me to go back in time quickly. Thus, I need to have a daily snapshot of a few Dynamics 365 tables and be able to quickly select the refernce date.

Might Azure Data Lake be the right tool? Or should I consider a replication (Replicate data to Azure SQL Database using Data Export Service - Power Platform | Microsoft Docs) and then build some job which creates a daily copy?

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Lucas.boaventura 35 on at

Like (0)

Report

RE: Daily data snapshot of Dynamics 365 online tables (accounts, contacts, leads, custom entities)

Hi Kiril,

I recommend Dynamics 365 Sales Insights Premium. For more information: https://docs.microsoft.com/en-us/dynamics365/ai/sales/analyze-deals-flow-between-snapshots#analyze-deal-flow-between-dates-in-early-access

Regards, Lucas Boaventura.

Santa Catarina - Brazil

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Daivat Vartak (v-9d... 225 Super User 2025 Season 1

#2

Muhammad Shahzad Sh... 95

#3

Vahid Ghafarpour 82 Super User 2025 Season 1

Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans