Jonathan Heide on 25 Oct 2014 07:57:08
S-Q-L-A-Z-U-R-E please
- Comments (7)
RE: SQL Azure
I cannot just connect poower BI to my sql azure and get reporting? I have to do it through Excel?
RE: SQL Azure
I dont see a SQL Azure data source in datasets. Where is it?
RE: SQL Azure
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
RE: SQL Azure
Great, thanks
RE: SQL Azure
This is implemented now on the new PowerBI Preview, is there a point to keeping it open?
RE: 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.
RE: SQL Azure
PQ refresh with SQL Azure data source!!!