Excel Online – Refreshing Data to a SQL Azure Database

Below are the steps to connect to SQL Azure Database and refresh this Data in Excel Online. 1. Open the Excel Rich Client > Data > From Data Connection Wizard > From Data Connection Wizard 2. Choose Other/Advanced 3. Choose SQL Server Native Client 11.0 Note: if you do not have see SQL Server Native…


Excel Online – PivotTable Operation Failed

I recently worked with a customer who was clicking on a slicer in an Excel Online PowerPivot workbook and getting the below error: After many days of analyzing logs, it was determined the cube was showing as being "Unprocessed".  Therefore the refresh could not complete.  The fix was to re-calculate the workbook (in PowerPivot).   To do this, you will need…