Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Can't read Phone Call Activity Records using Tabular Data Stream (CDS endpoint)

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

We are trying to read phone call activity data using the following service:

https://powerapps.microsoft.com/en-us/blog/tabular-data-stream-tds-protocol-endpoint-for-common-data-service-cds/

Even when we grant Read permissions at the BU level to the Phone Call entity, we still cannot read the Phone Call records from the msdyncrm_phonecallactivity table.

Does access to msdyncrm_phonecallactivity come from Dynamics or a completely different set of access roles?

Thank you,

Tony

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Can't read Phone Call Activity Records using Tabular Data Stream (CDS endpoint)

    Even though dbo.phonecalls was not in the SSMS, we queried this exact table and it came back with the data we want. Your response made us try that query. Thank you!

    SELECT TOP 10 * FROM dbo.phonecalls

  • Verified answer
    Nya Profile Picture
    Nya 29,058 on at
    RE: Can't read Phone Call Activity Records using Tabular Data Stream (CDS endpoint)

    Hi Tony,

    If you’re going to access the data of Phone Calls, which you need is the phonecall entity instead of the msdyncrm_phonecallactivity.

     pastedimage1624415685638v1.png

    The data of the entity can be transformed normally.

     pastedimage1624415691855v2.png

    If you have further problem about it, it is recommended to post your issue to the forum of Power Virtual Agents for more help.

    Here is the link:

    https://powerusers.microsoft.com/t5/Power-Apps-Community/ct-p/PowerApps1

     

    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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,160 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans