Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

arthi
Microsoft Employee
‎04-27-2021 09:54 AM

On-premises data gateway April 2021 update is now available

We are happy to announce that we have just released the April update for the On-premises data gateway (version 3000.79.6)

 On-premises_data_gateway_February_2022_update_is_now_availableOn-premises_data_gateway_February_2022_update_is_now_available

 On-premises_data_gateway_February_2022_update_is_now_availableOn-premises_data_gateway_February_2022_update_is_now_available

Here are some of the things that we would like to highlight with this month’s  release:

  • Test single sign-on (SSO) configuration
  • GA -SSO for Refresh and DirectQuery
  • PowerShell enhancements
  • Compatible with the April PBI desktop
 

Test single sign-on (SSO) configuration

Single sign-on capability enables each user precisely see the data for which they have permissions in the underlying data source. We do, however, understand that setting up Single Sign-On (SSO) via the gateways using either Kerberos constrained delegation or Security Assertion Markup Language (SAML) is complex. With this new feature,  you now have the ability to test this configuration.

In the Manage Gateways page in Power BI, where you configure the data source for SSO, under Advanced Settings for the data source, provide a User Principal Name to test.

On-premises_data_gateway_April_2021_update_is_now_availableOn-premises_data_gateway_April_2021_update_is_now_available

If either the user cant be impersonated or if the user doesn't have access to the underlying data source, you will see the appropriate error which helps you identify the problem area for a potential fix.

On-premises_data_gateway_April_2021_update_is_now_availableOn-premises_data_gateway_April_2021_update_is_now_available

Also refer to our SSO troubleshooting docs for frequent errors and possible causes and additional details.

We hope this feature makes troubleshooting for Single Sign-On via the gateway significantly easier.

 

General Availability - SSO for Refresh 

About a year ago, we released SSO for Refresh for data sources supporting  Kerberos constrained delegation in public preview. This feature  uses Dataset owner's security context(UPN) for Refresh-based Reports.  We are happy to announce that this feature is now in GA.

On-premises_data_gateway_April_2021_update_is_now_availableOn-premises_data_gateway_April_2021_update_is_now_available

 

PowerShell enhancements

We released PowerShell scripts for the automation of gateway installation and management  last year. we have made some enhancements to these PowerShell scripts.

  • Ability to view a gateway data source using "Get-DataGatewayClusterDatasource".
  • Allow adding and removing of Service Principals as Data source users using Add-DataGatewayClusterUser.
  • Documentation updates for Add-DataGatewayCluster, Add-DataGatewayClusterUser and   Add-DataGatewayClusterDatasourceUser,
Please review our online documentation for additional details.

 

Compatible with April PBI Desktop 

This version of the gateway 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/run-time as in the April Power BI Desktop version.

Please continue to send us feedback for what new capabilities you’d like to see in the future.

0