You can use Power BI publisher for Excel to pivot tables, pin ranges, and charts to Power BI.
- The user manages the tiles such as remove them, refresh them, in Excel.
- Pinned items must be removed from the dashboard in the service (removing in Excel only deletes the connection).
- The Power BI Publisher for Excel is also used to connect from Excel to datasets which are hosted in the Power BI Service.
- An Excel pivot table is generated with a connection (ODC file) to the data in Azure.
The Publisher installs all necessary drivers on the local machine to establish connectivity.