Implementing Microsoft Dynamics 365 Business Central On-Premise - Fourth Edition

Microsoft Excel and PowerPivot add-in

Among all the applications that are out there, an extensively used one is probably Microsoft Office Excel. There is a free add-in for Excel called PowerPivot that can consume OData web services—we can do that as follows:

1. If you're using Microsoft Excel 2013 or later, you can enable PowerPivot 2013 by going to the Add-in page from the Options menu. Alternatively, you can download PowerPivot by performing a quick search on the internet, which will lead you to the download page.

2. The installation of PowerPivot will create a new tab in the ribbon bar of Microsoft Office Excel:

3. Open Microsoft Excel 2013. ...