SQL Azure

This comment is geared more toward all data sources, not any one in particular. Until a Data Source Type (OData, SQL on prem, SQL Azure, Oracle, Excel, etc.) has fully functioning and integrated data refresh capabilities, such data source type I consider to be 'playground material' or 'sandbox'. Yeah, it's nice to have OData sources in Power Query that I can host on a Power BI site, BUT I CANNOT refresh them AUTOMATICALLY, so they are useless to me. Once a Data Source Type is created, the VERY NEXT STEP for the Microsoft Dev Team should be to figure out how to get it refreshed on a schedule. There are TONS of ways to get data into Power Pivot models, PBIX data models and Power BI dashboard sites, but as of this writing, VERY FEW of them support automatic data refreshes. In Power BI, I can't refresh a connection to an Azure SQL instance WITHOUT Data Management Gateway up and running connected to an On Premise server? ( I need an On Premise connection to do cloud-to-cloud refresh? WHAT?) Until there is a significant improvement in the automatic data refresh capabilities, this product (I predict) will not see widespread adoption by the business community that Microsoft is hoping for.