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
Icon for Super User rankSuper User
2 years ago

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

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

    That does get around the issue.  Nice and fast, no error. Only issue which is a new one is the table name gets appended to all columns in the live connection.  I wonder if there is any way to prevent that.

     

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper 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
        Icon for Helper I rankHelper 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?