Refreshing Excel Workbook data from on prem data sources

Question

What is the on prem&nbsp;refresh story for Excel workbooks in Office 365 in the new service? Currently the Data Management Gateway facilitates this. Will the DMG continue to be used, or will it be replaced by a different mechanism?

jbocachica · Answer

Hi, the DMG will not be replaced, just updated, by now, the Analysis Services connector is available for download and testing, now you will be able to update your dashboards and reports not only from your OLTP but from your Analysis Services Tabular also.

Regards

diverdown1964 · Answer

Thanks John - Yup - the connector is great for those live connections, but I'd love to see some clarity on the DMG story.

jenunderwood · Answer

There will be more information on the DMG and on prem data&nbsp;refresh coming soon this "summer".

jenunderwood · Answer

There was a significant on-prem data refresh release today. Check out http://blogs.msdn.com/b/powerbi/archive/2015/07/07/refresh-for-on-premises-sources-is-here.aspx&nbsp;
&nbsp;
Starting today, in Power BI you can refresh datasets connecting to your on-premises sources such as SQL Server. Any workbook created using Power BI Designer, Power Query or Power Pivot are supported. For these datasets the Power BI Personal Gateway enables automated refreshes against on-premises data sources in your organization, all via a single gateway you can install directly on your desktop machine.
All common data sources are supported:

SQL Server
Oracle
Teradata
IBM DB2
PostgreSQL
Sybase
MySQL
SharePoint List (on-premises)
File (CSV, XML, Text, Excel, Access)
On-premises SQL Server Analysis Services models (uploaded data; not live connections)
Folder
Custom SQL/native SQL

In addition to on-premises sources refresh, we have enabled two new features for refresh from cloud or on-premises:

More frequent refreshes – you can now set up a schedule to refresh more than once a day
Refresh failure notification/history – you can be notified via email when a refresh fails and also find detailed information in the service for the cause of the failure. You can also view your refresh history and see any failures/successes.

In this blog post, we’ll introduce these new features.
In order to refresh a dataset connecting to an on-premises data source you need to install and configure the Power BI Personal Gateway.
&nbsp;
More information is available on the Power BI blog.
&nbsp;
&nbsp;

timrodman · Answer

Sweet!!! I'm looking forward to taking it for a test drive.

Forum Discussion

Refreshing Excel Workbook data from on prem data sources

7 Replies

Related content

Incremental Refresh on Dataflow sourced from SharePoint

Scheduling Excel Workbook Connection (Dataflow) Refresh

Power Query Opens Source Workbook on Refresh

Workbook into Lakehouse

Memory consumption issue while refreshing the data source