Survey Responses missing from msfp_questionresponse

(0) Share

Report

Posted on by BeanCV

The HR department recently sent out several surveys and I have been tasked with reporting the results in Power BI. I can retrieve the necessary msfp_ tables into Power BI and use the msfp_survey, msfp_question and msfp_questionresponse tables to report off of. My problem is that there are responses missing from msfp_questionresponse. Specifically all responses before 6/9 10:40AM. I can see responses in the Customer Voice portal before this time, but they are not in the msfp_questionresponse table.

1. Any idea what happened to cause the responses to not show up in msfp_questionresponse?

2. If the responses show in the Customer Voice portal, where are they stored?

Thanks for the help.

I have the same question (0)

All responses (8)

Answers (1)

thebruuu 422 on at

Like (0)

Report

Hi Bean

You are looking in the right table

Beware, the table you are looking at is not the CustomerVoice operational table and there may be a delay in the refresh of the dataverse table

Those "missing" responses do they show up in the Report section of CustomerVoice Project?

Was this reply helpful? Yes No
BeanCV 25 on at

Like (0)

Report

Hey thebruuu,

That's correct. The responses show up in the Report section of CustomerVoice Project, but not the msfp_questionresponse table. The missing responses were the earliest ones. Everything after 10:40AM on 6/9 has shown up. I don't have any experience on survey creation or distribution. I was wondering if HR didn't have a checkbox checked to record the responses or something like that until 10:40AM on 6/9. Is there a way I can report off the 'operational' table?

Was this reply helpful? Yes No
thebruuu 422 on at

Like (0)

Report

Hello

I am not aware of any flag/checkbox that would affect the recording of responses

If you need an industrialised solution, just keep on using the dataverse tables and open a support-ticket to Microsoft

If you are ok with unofficial and unsupported solutions, you may try understand how the browser front-end gets the infos via API calls to the CustomerVoice operational back-end

Just take a look at the browser dev console (F12):

For example, when smone clicks on the name of a respondent, in the respondent list in the report section, to look at the answers of the clicked respondent, the following url is called:

customervoice.microsoft.com/.../getresponseinfo

It's a lot of effort ... but if you manage to reverse engeneering all the handshake and parameters to get the api call to work, you will for sure get all the responses as the API gets the data from the operational database (I am 100% sure about that : I managed to get infos that are not available in the dataverse, the translations, via some other API calls reverse engineered in this way)

In the community last week, there was a couples of guys that were pretty close to find a way to use the API, including authentication

Good Luck

Was this reply helpful? Yes No
Pedro Sacramento on at

Like (0)

Report

Hi BeanCV ,

My first guess was that you're looking at partial responses (paused responses). Maybe the feature was enabled recently for the CV Project, but looking at the documentation, the partial responses are not saved and are not displayed in the CV portal either. See https://docs.microsoft.com/en-us/dynamics365/customer-voice/save-survey-progress

Could it be that there are copies of the survey configured to use different environments?

The environment is the Customer Voice Project must match the environment where you're pulling data from:

If there was a different version of the survey before 6/9 that was configured to use a different environment, that could explain why you're not seeing data before that date/time. Another possibility could be if you're filtering the msfp_questionresponse by state and somehow the state of the records was changed.

Was this reply helpful? Yes No
BeanCV 25 on at

Like (0)

Report

Thanks for the reply. I believe sniffing through the API calls is probably beyond my abilities. When our administrator returns I believe I'll have her put in a support-ticket to Microsoft

Was this reply helpful? Yes No
BeanCV 25 on at

Like (0)

Report

Hi Pedro,

Thanks for the reply. I verified that we only have one environment and it hasn't changed.

Was this reply helpful? Yes No
Verified answer

BeanCV 25 on at

Like (2)

Report

We have figured it out.

My account and the service account running the Power BI report were given access to the Project at 10:40AM on 6/9. Any responses before that time remained unavailable to me. Our O365 administrator could see all the responses in msfp_questionresponse. She gave me access to a record from 6/8 in the Dynamics 365 portal and when I refreshed, I could see it. So, I don't know if this is a bug or a feature, but it's a good idea for any accounts that are going to report off the data to have access before the survey goes out and responses start coming in.

Was this reply helpful? Yes No
thebruuu 422 on at

Like (0)

Report

Excellent.

I always worked with admin accounts so I had never been faced with this issue.

Thank you for sharing

Was this reply helpful? Yes No