Export is missing data

[saud968]

I am trying to below data but some of the data is missing, in Power Query I have merged the queries in the backend. 

Here is PBIX File  - https://drive.google.com/file/d/1zNblRbnizmqtnAqMTJ7rmX4njm6ZeqDZ/view?usp=drivesdk
RAW File - https://docs.google.com/spreadsheets/d/1r_aYyCZrzwL0358kd4UUF3KgaueeaTUW/edit?usp=drivesdk&ouid=1093...
@parry2k @Idrissshatila @Greg_Deckler @amitchandak @lbendlin @Anonymous  @Vijay_A_Verma @slorin @BA_Pete 

[lbendlin]

Like what I showed above with the matrix visual?

[saud968]

No like this one

[lbendlin · Accepted solution]

see attached

[saud968]

@lbendlin this worked thank you so much such a simple resolution I took such long route. hehe thank you for your help

[saud968]

@lbendlin to add the data is pulled in Power BI via the Snowflake model. and not excel

[lbendlin]

access denied - please check link

[saud968]

please try now it should work

[lbendlin]

That is a rather interesting way of doing an unpivot.  I would recommend you stick with the standard approach.  Note that merges in Power Query are expensive and should be avoided where possible.

Can you post the "Test PC RAW.xlsx"  as well?

[saud968]

I have attached the file "Test PC RAW.xlsx" Please let me know what can be done to achieve the questions in column "QUESTION_NAME" and CSAT & CES in one row as they linked with Case Number

[lbendlin]

Please indicate what the expected outcome is.  Here is an example of using the raw data (without any transforms) in a matrix visual

[saud968]

Below is the expected outcome in the table visual, after merging queries it works but exporting the data skips a lot of rows. 

[lbendlin]

Not all cases have records for all questions

That's likely the reason why you think there is missing data.

I still don't understand why you need to do all these merges. The initial table should be sufficient.

[saud968]

So it is the stakeholder's requirement that they want to see all the questions related to that case number in a single row with CES and CSAT value