OnPrem Cube to Excel file hosted on SharePoint Online

Hi

How can I get an xls hosted on SharePoint Online to pull data from a Analysis server cube hosted onPrem?

Looking at On-Premise Data Gateway but not sure if that will work? 

Thanks in advance.