Hi v-haibl-msft
Using personal gateway didn't work. It is still saying I need PowerBI Pro to get the scheduled refresh.
Initial setup:
Two files on OneDrive-Business, accessed via web url
Google Analytics
Revised setup
Two files on OneDrive-Business, access "locally" via the C:\Users\<username>\OneDrive Business
Google Analytics
Personal Gateway connections okayed, added the two files as data sources
HOWEVER, this setup won't work regardless even if scheduled refresh did work, because I initially I get an error saying that it couldn't connect to the Gateway because another process was running. I then found out that, the OneDrive app, if syncing were on, would access the same resource, and the PBI gateway service couldn't access it. ie. if I need to turn off sync for it to work then the data isn't refreshed via OneDrive, so I'd need to manually refresh the data.