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.

     

bruceandersonBI's avatar
bruceandersonBI
Helper I
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

you got the SELECTCOLUMNS syntax backwards.

 

EVALUATE SELECTCOLUMNS(SUMMARIZE ( 'WCO', 'WCO'[No.], 'WCO'[MHI Claim Date] ),"No.",[No.],"Claim Date",[MHI Claim Date])