Microsoft Fabric Updates Blog

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)

 

 

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.

Related blog posts

On-premises data gateway April 2021 update is now available

June 16, 2024 by bagweb

Testing Cascading Messaging portal changes

November 20, 2023 by Anshul Sharma

As part of the One logical copy effort, we’re excited to announce that you can now enable availability of KQL Database in Delta Lake format. Delta Lake  is the unified data lake table format chosen to achieve seamless data access across all compute engines in Microsoft Fabric. The data streamed into KQL Database is stored … Continue reading “Announcing Delta Lake support in Real-Time Analytics KQL Database”