Expose On-Premise Data to the Cloud

Expose On-Premise Data to the Cloud

Microsoft has just released a client-side component that creates a bridge between on-premise data and their Cloud-resident Power BI for Office 365.

The Data Management Gateway installs (DataManagementGateway.msi) on a local computer running any of the following operating systems:

  • Windows 7
  • Windows 8
  • Windows Server 2008 R2
  • Windows Server 2012

Once installed and connected, on premise data sources can be registered with Power BI for Office 365 as and then used to run, manipulate and produce business analytics using the Power Query add-in for Microsoft Excel or Microsoft SharePoint Online. You can also publish and index on-premises data sources as OData feeds.

The download is available from here: Microsoft Data Management Gateway

If you're unfamiliar with Power BI for Office 365, here's some great resources to get started:

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.