In addition to the Analyze in Excel feature from the Power BI service, even deeper integration with Excel is possible via the Power BI publisher for Excel add-in. This add-in can be downloaded from the Power BI service via the same drop-down menu used for the On-premises data gateway, as illustrated in the Configuration of on-premises gateway section of Chapter 9, Managing the On-Premises Data Gateway. Once downloaded and installed, a Power BI tab will be visible on the Excel ribbon:

Via the Connect to Data button, users can access the reports and datasets of the app workspaces they have permissions to. For example, rather than navigating to the specific Power BI report of interest in the Power BI service to access the Analyze in Excel feature, the user could simply select the workspace and a report or dataset from a dropdown in Excel.

In the following screenshot, the user has clicked the Connect to Data button and navigated to the World Tour - New York app workspace:

The same Power BI workspaces and datasets accessible from Power BI Desktop can be accessed via the Connect to Data feature. Additionally, the Power BI publisher for Excel enables users to pin items, such as ranges of cells or charts, to dashboards in the Power BI service and to manage updates to these local items. Additional information on the Power BI publisher for Excel is available here: http://bit.ly/2nuzQIt.