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 adva...