We are happy to announce that we have just released the April update for the On-premises data gateway (version 3000.79.6)
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.
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.
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.
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.