Frequent Contributor

I am looking to have an active data connection from an Excel file in Excel Services on SharePoint Online (O365) that has a data connection to an on-premises SQL database.

 

Need to be able to have data refresh work like it does with SharePoint on-premises.

 

The DMG used for PowerBI doesn't appear to have connections for Excel.

 

I am looking for "out-of-the-box" solution (or close to one). 

 

Is this still a supported scenario? It was widely used in on-premises SharePoint system as is currently blocking some key Office 365 adoption.

 

Thanks!

www.000webhost.com