SQL Azure

PQ refresh with SQL Azure data source!!!

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.

Hey Suraj, when you upload an Excel workbook to Power BI a dataset is created. On the dataset, you can schedule a refresh. If the data source in the dataset is SQL Azure & you have scheduled a refresh, the dataset will get refreshed as per the schedule. You can learn more here - http://support.powerbi.com/knowledgebase/articles/474669-refresh-data

This is implemented now on the new PowerBI Preview, is there a point to keeping it open?

Great, thanks

I dont see a SQL Azure data source in datasets. Where is it?

I cannot just connect poower BI to my sql azure and get reporting? I have to do it through Excel?