web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Activity Party entity to SQL Server db

(0) ShareShare
ReportReport
Posted on by 15

Hello,

I'm trying to figure out a way to export the Activity Party table to the SQL server database for reporting purposes. Earlier we used Data Export Services to export this data. However, since DES is deprecated I'm trying to find an alternative method to do this. I followed the manner suggested by Microsoft to use Dataverse with Synapse link. But as activityparty is not showing in the table list in dataverse (In MS Power Apps portal). I'm quite new to the dynamics and not sure how to achieve this (Or whether I'm taking a completely wrong approach). Is there anyway to achieve this ? 

Thanks in advance!

I have the same question (0)
  • Amila Akalanka Profile Picture
    15 on at

    Hello,

    I'm trying to figure out a way to export the Activity Party table to the SQL server database for reporting purposes. Earlier we used Data Export Services to export this data. However, since DES is deprecated I'm trying to find an alternative method to do this. I followed the manner suggested by Microsoft to use Dataverse with Synapse link. But as activityparty is not showing in the table list in dataverse (In MS Power Apps portal). I'm quite new to the dynamics and not sure how to achieve this (Or whether I'm taking a completely wrong approach). Is there any way to achieve this?

    Thanks in advance!

  • Suggested answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at
  • Amila Akalanka Profile Picture
    15 on at

    Hi Abdul Wahab,

    I checked both articles and tried the ADF approach. But still, no luck as the actitivtyparty entity is not showing in the available list of entities for the copy.

    Thank you!

  • Suggested answer
    Bipin D365 Profile Picture
    28,983 Moderator on at

    Hi,

    Make sure Change Tracking is enabled for your entity.

    learn.microsoft.com/.../azure-synapse-link-synapse

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 137 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 57

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans