You’re offline. This is a read only version of the page.
Not a developer or data scientist by trade but bear with me--
Background:
The company I work for uses customer voice for surveying but as our CRM system is still early days, we don't use contacts from the Dynamics. Instead, we send the survey invites via email and use the contact import function to include certain key pieces of info as context parameters/metadata (if I'm getting the term right).
We have a Power BI report that connects to the DataVerse using a service account's credentials (the service account also created the survey)--I'm viewing all of the survey information using the service account's connection in Power BI's query editor.
Issue:
One of the responses to the survey has the context parameters that would have been included in one of our email invites, but it doesn't have a survey invite id in the response table (msfp_surveyresponse). There is a likely invite ID in the invite table (msfp_surveyinvite) for the same project that was sent out the same day.
I am wondering if someone might have deleted an invitation, or if something might have happened when I sent the survey out--I've been the only person sending them out and have used the same process for all of the invitations. The rest of the responses all have their related invite ID. I'm not sure what or where else to look to see what might have gone wrong.
Hi, I had the same issue. This was caused by a delay in saving of the invitations. In some cases that took 1,5 hours for no reason, or the invitation was never in the table.
When the respons was received before the invitation was in the database I saw the same thing as in your case.
For this I created a case with MS support and all was solved within 24 hours!
Good luck!
Share
Report
All responses (
Answers (
562
