News and Announcements icon

Dynamics 365 CommunityForums Customer Voice forum Remove Unused Question...

Customer Voice forum

Suggested answer

Remove Unused Questions from Copied Survey

(0) Share

Report

Report

Posted on by SVAnderson

25

I copied a previous Customer Voice survey for a new survey, and am now trying to create a Power BI dashboard from the data. I've expanded the question text, and can see all the right answers. However, the questiontext column shows some questions that aren't in the current survey. One of them is long enough that it's preventing me from downloading the information (a "Model object name...is longer than the allowed 512 characters" error). I'm trying to remove the unused questions (the model object name) from the data model. Any ideas?

Thanks.

Categories:

Survey Authoring

All responses Img

All responses (3)

Answers Img

Answers (0)

thebruuu 422 on at

Like (0)

Report

RE: Remove Unused Questions from Copied Survey

So strange !

Clearly Copy and Delete operations are not yet stable :/
Suggested answer

SVAnderson 25 on at

Like (0)

Report

RE: Remove Unused Questions from Copied Survey

Thank you for your response. Yes, I'm connecting directly to the msfp_dataverse table. I think the issue has to do with some "orphan" questions that transferred over when I copied the previous survey. I ended up re-creating the survey from a new survey and it seems to have solved my issue.
thebruuu 422 on at

Like (0)

Report

RE: Remove Unused Questions from Copied Survey

Hello SVAndeson

I am not sure to understand the way you are proceeding

Do you get the data from the msfp_ dataverse table?

By doing so, you can directly connect Power BI to Customer Voice data without any need to download data ...

docs.microsoft.com/.../entity-reference

If you are already working in this way, you should be able to filter out unwanted questions/reponses by filtering out the unwanted surveys,

The fastest way is by looking directly at the survey id value, and getting the id of your survey from the survey web page looking at the url formid parameter

Regards

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,252 Super User 2024 Season 2

#2

Martin Dráb 228,089 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans