Refresh for on-premises sources is here!

Posted on Updated on

According to Microsoft PowerBI team:

One of the most awaited and requested feature is now available in Power BI. 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

this is really exciting  – even a normal workstation can do the work!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s