Forum Discussion

Magkru's avatar
Magkru
Frequent Visitor
2 years ago

Not all likert responses visible in data model

Dear All,

I am struggling with this issue for days and I cannot find any logical explaination to issue encountered.

 

I am trying to visualize responses from Customer Voice Analysis in PowerBI. I am trying to connect to CRM environment though Dataverse and everyting seems to be okay, all tables are listed here:

I imported all tables needed and then suprising fact happened. I seem to have all of the responses but those from Lickert question: they seem to be present in dataset randomly:

 

While I am 100% sure that all responses have been submitted (it was obligatory question) and all responses are visible in Excel when I export the data manually.

At first, I thought that it may be caused by connector - Dataverse does not suppprt multiline columns. However, when I use Common Data Service, the issue still exists.

 

When I see raw survey list option - I see something like this, simply not all question ids are listed (sorry for poor screenshot lol)

 

 

 

No RepliesBe the first to reply