When I double click on a pivot table the new spreadsheet shows a broken data set

Copper Contributor

When i uncheck the filter option it populates the data. Running the same sheet in the online excel program the action works correctly.  (double click on sum data, new sheet is generated and data is populated)  

The data is correct the issue is the new spreadsheet on the desktop version does not fill the content until you some action.  Bug in Excel?  setting that is missing?  

1 Reply

@don_hartung_BPI 

By default is shall show first 1000 records (it could be changed in connection properties). Or it breaks earlier?