Forum Discussion

bruceandersonBI's avatar
bruceandersonBI
Icon for Helper I rankHelper 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.

     

bruceandersonBI's avatar
bruceandersonBI
Icon for Helper I rankHelper I
2 years ago

Many thanks!  I have no error when exporting to live.  However, I see live option is not available  for "Underlying Data".  So I will need to add all of the fields into the BI report (80+) so they come out in the summarised option, hopefully.  I will try that.