Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Magkru
Frequent Visitor

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:

Magkru_0-1698223127929.png

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:

 

Magkru_1-1698223245987.png

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)

 

Magkru_2-1698223576623.png

 

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.