Power BI – Data Management Gateway Installation

You can download the Data Management Gateway here or when you create your gateway in the Power BI admin center. Version 1.2.5303.1 was release in July 2014 added support for:

· scheduled data refresh for Power Query data connections with the following data sources: File (Excel, CSV, XML, Text and Access), Folder, IBM DB2, My SQL, Sybase, SQL Azure, PostgreSQL, Teradata, Sharepoint List, OData Feed, Azure Market Place, Azure HDInsight, Azure Blob Storage and Azure Table Storage

· Enhanced scalability for Data Management Gateway, now supports up to 10 instances

· Fixed timeout issues, now gateways supports data refresh request lasting up to 30 mins.

First we need to configure a gateway in the Power BI admin center.

Once logged into the Power BI admin center, go to the gateways tab click the plus sign to create a new gateway.

clip_image001

Details – provide a name for the gateway and a description

clip_image003

Gateway instances – for this example we will only have 1 instance

clip_image005

Click create

Install and register – here you are provided the download link to the data Management gateway and the gateway key that you will need when configuring the service we just installed.

clip_image007

clip_image008clip_image009clip_image010clip_image011clip_image012clip_image013

Note on the final screen of the install wizard, there is a new local security group created. The Data Management Gateway users group is used to control who has admin access to the gateway.

Next we need to configure the service we just installed to the gateway we created in the Power BI admin center.

clip_image014clip_image016

clip_image018

Select a certificate

clip_image020clip_image022

In a future blog post I will cover how to create a data source in Power BI.

Advertisements
This entry was posted in Power BI and tagged . Bookmark the permalink.

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