Excel Online – External Users cannot refresh data connections

Scenario: You’re using an Excel file that contains a Excel Power Pivot Model with external data connections and currently the data refresh in Excel Online is working without any issues for the internal users of the organization tenant. When this file is shared with external users of the tenant, this users are not able to…


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…