<div>
<div class="content wysiwyg-content">
Just a question regarding the best direction and tools to use. I have published reports to sharepoint using PowerBi and the Microsoft Gateway and the schedule allows me to refresh the data to the web. All works well. &nbsp;<br />
However, I have an excel workbook with a pivot table linked to an SQL database. Company management would like to be able to view this spreadsheet remotely. I am looking for direction on what are the steps/ tools required to publish an excel workbook to Office 365/sharepoint and maintain the ability to refresh the data from the onsite SQL server either by request or on a schedule. <br />
I have looked a the PowerBi matrix but it doesn't really give me the same level of flexibility as an excel pivot table.<br />
Thanks in advance.
</div>
</div>


Just a question regarding the best direction and tools to use. I have published reports to sharepoint using PowerBi and the Microsoft Gateway and the schedule allows me to refresh the data to the web. All works well.  
However, I have an excel workbook with a pivot table linked to an SQL database. Company management would like to be able to view this spreadsheet remotely. I am looking for direction on what are the steps/ tools required to publish an excel workbook to Office 365/sharepoint and maintain the ability to refresh the data from the onsite SQL server either by request or on a schedule. 
I have looked a the PowerBi matrix but it doesn't really give me the same level of flexibility as an excel pivot table.
Thanks in advance.

How to share an Excel workbook with data connection in Sharepoint/Office 365

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Pivot Tables

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.