Sharepoint Online - Data Set Refresh

Hi,

I created a visual reports in PowerBI Desktop by connecting to an Excel File in Sharepoint Online. Published it from Desktop to my online Workspace in App Service.

Now, my understanding was that the Dataset will be refreshed automatically every one hour as my Datasource is Excel on Sharepoint Online. Unfortunately, it doesnt work that way and only Scheduled Refresh works.

Only when I create a new Datasource in PowerBI App Service it refreshes every one hour, but how can I now point this new Dataset to my reports that are published in the Workspace.

This is what Microsoft website says: 

https://docs.microsoft.com/en-us/power-bi/refresh-data#excel-workbook-with-tables-of-data

When you connect to a file on OneDrive, or SharePoint Online, your reports and dashboards will show data as it is in the file. In this case, your Excel workbook. Power BI automatically checks the file, about every hour, for updates. If you make changes to the workbook (stored in OneDrive or SharePoint Online), those changes are reflected in your dashboard and reports within an hour. You don’t need to setup refresh at all. However, if you need to see your updates in Power BI immediately, you can manually refresh the dataset by using Refresh Now.

Appreciate your help.

Thanks