Forum Discussion

bruceandersonBI's avatar
bruceandersonBI
Helper I
2 years ago
Solved

"Compressed Stream" error with Analyze in Excel

We are using the Analyze in Excel addin with a certain report, pulling the data from service.  This report as around 500000 records.  There are about 80 fields we need to add in a flattened pivot sty...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Try Export to Excel with live connection and see if you get the same error.

  • bruceandersonBI's avatar
    bruceandersonBI
    2 years ago

    So this one is a bit beyond my DX skills (lack thereof).

    I stripped it back so I can get the syntax down to just two columns:

     

    DEFINE VAR __DS0Core =SUMMARIZE('WCO','WCO'[No.],'WCO'[MHI Claim Date]) VAR __DS0BodyLimited = TOPN(500000,__DS0Core,'WCO'[No.],1,'WCO'[MHI Claim Date])EVALUATE __DS0BodyLimited ORDER BY 'WCO'[No.], 'WCO'[MHI Claim Date]

     

    I changed it to this:

    DEFINE VAR __DS0Core =SELECTCOLUMNS(SUMMARIZE('WCO','WCO'[No.],'WCO'[MHI Claim Date]),'WCO'[No.],"No.",'WCO'[MHI Claim Date],"Claim Date") VAR __DS0BodyLimited = TOPN(500000,__DS0Core,'WCO'[No.],1,'WCO'[MHI Claim Date]) EVALUATE __DS0BodyLimited ORDER BY 'WCO'[No.], 'WCO'[MHI Claim Date]

     

    But then I get

    Pretty sure I just have a peice of the syntax in the wrong spot.

     

lbendlin's avatar
lbendlin
Super User
2 years ago

Yes, you can modify the DAX query via SELECTCOLUMNS.  But it will be quite tedious when you have so many columns.

bruceandersonBI's avatar
bruceandersonBI
Helper I
2 years ago

If it will work, I would embrace the tedious.  Ihave searched aroud for that but not finding anything in my resources with DAX on how to use SELECTCOLUMNS in that way.  Would greatly appreciate if you can point to how/where to do that?