• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

On-premises data gateway July update is now available

July 27, 2018   Self-Service BI

We are excited to announce that we have just released the July update for the On-premises data gateway. Here are some of the things that we would like to highlight with this month’s release:

  • Public preview for custom data connectors support in the Enterprise gateway
  • Requests distribution across all gateways in a gateway cluster
  • Support for Kerberos-based Single Sign-On for Spark in Power BI Service
  • A diagnostic test to check if your gateway can access the correct ports it needs to function properly
  • The on-premises data gateway now includes the July version of the mashup engine

 

You can download the July release (build number: 14.16.6768.3) from the link below and continue reading for more details about each enhancement.

 

8da9edc3 b7c9 4bfd 98f5 3a4dbd33e606 On premises data gateway July update is now available

 

Custom data connectors support in the Enterprise gateway

 

Data Connectors for Power BI enable users to connect to and access data from an application, service, or data source. For some time now, you have been able to develop custom connectors and use them in Power BI Desktop. You can find more details on how to develop and use custom data connectors here.

In April, we announced the support for custom connectors in the personal gateway. This month we are excited to announce that the enterprise gateways now support custom data connectors as well.

 

Here is a quick guide on how to enable and use this new capability

When you install the July version of the on-premises data gateway, you’ll see a new “Connectors” tab in the configurator with an option to choose a folder to load the custom connectors from. Make sure you pick a folder that can be accessed by the user running the gateway service (which is “NT SERVICE\PBIEgwService” by default). The gateway will automatically load the custom connector files located in that folder and you should see them in the list of the data connectors.

 

e60c830d b3dd 4bc1 a307 669482c94303 On premises data gateway July update is now available

 

In the gateway settings page in the Power BI service, you will see a new option when you select the gateway cluster to allow using custom connectors with this cluster. Make sure all gateways in the cluster are updated to the latest July release for this option to be available. Now select that option to enable using custom connectors with this cluster.

 

7b2b597a 12b0 498e 8e46 6a9f189e7646 On premises data gateway July update is now available

When this option is enabled, you will now see your custom connectors as available data sources that you can create under this gateway cluster. Once a data source is created for your new custom connector, you can now refresh Power BI reports using that custom connector in the Power BI service.

a86c6b90 e63e 4e17 a0b6 a013847db96c On premises data gateway July update is now available

 

A few important things to note

  • Make sure the folder you create is accessible to the background gateway service. Typically, folders under your user’s Windows folder or system folders won’t be accessible. The gateway configurator will show a message if the folder is not accessible.
  • Custom connectors with OAuth authentication are not yet supported in this release. The OAuth support will be coming soon via a service update.
  • Custom connectors using Direct Query are also not supported yet. This support should arrive with a later update.

 

Distribute requests traffic across all gateways in a cluster

You can choose to allow traffic to be distributed across all gateways in a cluster. In the Manage gateways page in the Power BI service, when you click on a gateway cluster in the list on the left navigation tree, you can enable the option to “Distribute requests across all active gateways in this cluster”

 

72057df5 c54b 496a a23b 21f03a4e8358 On premises data gateway July update is now available

 

Support for Kerberos-based Single Sign-On for Spark in Power BI Service

In this month’s release, we’re adding Kerberos-based Single Sign-On support for the Spark connector. This allows end-user’s identity to be mapped to underlying Spark users when consuming a DirectQuery-based report on top of Spark in the Power BI Service. You can find more details about single sign on support using Kerberos here.

 

Network Ports Test

The network ports test is a tool to check if your gateway can access the correct ports for all remote servers that are required by your gateway for transferring data. If the network ports test fails to connect to any of the ports, your gateway may experience network issues. If you are currently experiencing network issues with your gateway, run a network ports test to ensure that you have the optimal network environment.

 

Start a new test

To run a new network ports test, in the On-premises data gateway user interface, select Diagnostics, and then select the Start new test link near the bottom of the page, as shown in the following image. To start a new network ports test, you must be signed into the On-premises data gateway user interface

 

1273b6af fa73 4673 b901 352399da2722 On premises data gateway July update is now available

When executing the network ports test, your gateway will retrieve a list of ports and servers from Azure Service Bus and then it will attempt to connect to all the servers and ports. When the Start new test link reappears, the network ports test has finished executing.

 

Test results

A summary of the test can be seen below the Start new test link as Recent test results. The two results are Completed (Succeeded) and Completed (Failed, see last test results). If the test succeeded, then your gateway successfully connected to all the required ports. If the test failed, then your network environment may be blocking these required ports and servers.

a7b79192 7c17 481f 92e2 5be2e252b978 On premises data gateway July update is now available

To view the results of the last completed test, select the Open last completed test results link, as seen below. The test results will open in Windows’ default text editor.

The test results list all the servers, ports, and IP addresses that are required by your gateway. If the test results display Closed for any ports as shown below, ensure that your network environment is not blocking the connection. You may need to contact your network administrator to open the required ports.

 

Updated version of the mashup engine

Last but not least, this gateway update includes the same version of the Mashup engine as the Power BI Desktop update released earlier this month. This will ensure that the reports that you publish to the Power BI Service and refresh via the gateway will go through the same query execution logic/runtime as in the latest Power BI Desktop version. Note that there are some Beta connectors that are still not supported outside of Power BI Desktop. Please refer to specific connector documentation for more details or contact us if you have any questions.

 

That’s all for this month’s gateway update. We hope that you find these enhancements useful and continue sending us feedback for what new capabilities you’d like to see in the future.

 

c6d4f297 4221 4777 86aa 8fdcc0a352ff On premises data gateway July update is now available

 

Additional resources:

· Try Power BI

· Follow @MSPowerBI on Twitter

· Join the conversation at the Power BI Community

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

available, data, Gateway, July, onpremises, Update
  • Recent Posts

    • Oracle Launches Version 21c
    • ‘Insecure’ Star Yvonne Orji To Develop Disney Plus Comedy Series
    • P2 Automation: What’s Exciting for Small Businesses in 2021?
    • IBM acquires Taos to supplement its cloud expertise as workloads shift
    • Get ready! Top Dynamics 365 Trends Coming your Way in 2021
  • Categories

  • Archives

    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited