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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Not all responses show...
Customer experience | Sales, Customer Insights,...
Answered

Not all responses showing in msfp_surveyresponse table that show up in Customer Voice UI

(0) ShareShare
ReportReport
Posted on by Smolcykr 5

Hi,

I am working in Power BI to create some reports - I've connected to (among other tables):

  • msfp_survey 
  • msfp_surveyinvite
  • msfp_surveyresponse

I have created the following relationships:

  • msfp_survey  to msfp_surveyinvite using msfp_surveyid
  • msfp_surveyinvite (activityid) to msfp_surveyresponse (msfp_surveyinviteid)

My problem:

  • In the Customer Voice UI, I see 5 responses
  • In msfp_surveyinvite, I can see these 5 invitations
  • However, in msfp_surveyresponse I am unable to find 2 of the 5 responses

Can someone help me understand why I can see 3 of the 5 responses - but not the other 2?

Thank you!!

pastedimage1609876241511v3.png

I have the same question (0)
  • Verified answer
    Arjun N Profile Picture
    Arjun N Microsoft Employee on at

    Hi,

    The availability of responses in CDS has a delay anywhere from 2 mins or over sometimes. The Customer Voice UI is from the primary storage and hence has realtime info and syncing to CDS has a little delay. Can you confirm if you are still not seeing the responses in CDS match with what you see in UI ? if yes, can you reach out at customervoice@microsoft.com.with your survey id and tenant id where you are seeing this.

    Thanks,

    Arjun

  • Smolcykr Profile Picture
    Smolcykr 5 on at

    Thank you Arjun.

    The responses I am not seeing are from 11/23/20 and 12/14/20 - so I'm guessing this is not a lag time issue.

    I will contact support as you suggested.

    Many thanks!

  • jwxc Profile Picture
    jwxc 20 on at

    Was a solution found to this problem? I am having a similar issue.

    I can see 69 responses to a survey in Customer Voice, but if I look at the Dataverse table in Power BI or Power Automate, it is only showing the first 62 response records and newer responses are nowhere to be found.

    Interestingly, I have set up a notification flow in Power Automate to send me an email every time a new record is added to the table and that has continued to send notifications for new records so they must be in there somewhere.

    I think I might have made a change to the survey questions after the 62nd response, but I presume this shouldn't affect the flow of data? What could be preventing the recent rows from showing up in Power BI?

  • Suggested answer
    Welly Lee Profile Picture
    Welly Lee Microsoft Employee on at

    Can you share your tenant ID to customervoice@microsoft.com? We will investigate

  • Community Member Profile Picture
    Community Member on at

    hi there

    Was a solution found to this problem? I am having a similar issue.

    I am not seeing responses from 04/01/21 to 04/06/21.

  • jwxc Profile Picture
    jwxc 20 on at

    Hi, I still seem to be missing a few unfortunately. I've had some contact from the team at Microsoft team though who have been looking into it.

  • Community Member Profile Picture
    Community Member on at

    I am experiencing the same issue and I have submitted a request to the email listed above.  I will update with the outcome.

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 80 Super User 2026 Season 2

#2
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 35 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans