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

In Excel, right click on one of the values then Table...Edit Query. The Command Text will have the DAX query that you can modify (among other things you can remove the silly 500K limit).  Encaplsulate the existing query with SELECTCOLUMNS and specify your desired colunm names.