Forum Discussion

saud968's avatar
saud968
Memorable Member
2 years ago
Solved

Export is missing data

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=109378584867630822700&rtpof=true&sd=true
parry2k Idrissshatila Greg_Deckler amitchandak lbendlin Anonymous  Vijay_A_Verma slorin BA_Pete 

General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

13 Replies

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        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's avatar
    saud968
    Memorable Member
    2 years ago

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