Pivote tabels support in office365

HI Team,

 

We have lot of pivot table reports in on-premise, we are planning to adopt Team to migrate all our scheduled refresh excel pivot reports to Teams SharePoint site to manage the reports access and refresh the reports. I wish to know more details from you in below things

 

1. Can we refresh pivot excel reports in Office365 share point site ?

2. Documentation on hosting pivot reports in office365 and connecting the reports with on-premise SQL database to refresh the reports with latest data on-demand and schedule times

 

Regards

GVS