Last week, Microsoft unveiled the feature summary for the July update of Power BI Desktop. In customary fashion, the company has now announced the latest monthly update for the Power BI On-premises data gateway, only a few days later. With this release, the pathway has been bumped to version 3000.51.7.
For starters, OAuth support via the gateway has now been enabled for SQL Server and Kusto connectors. Azure Active Directory (AAD) credentials can, as such, be used when attempting to create a connection with services acting as data sources, such as SQL Azure. Creating an SQL connection will now provide an OAuth2 authentication method under the data source settings, with the “Edit Credentials” option enabling users to sign in using AAD credentials.
With the standard mode for On-premises data gateway, Azure relays can now be set up with relay details provided by the customer. Previously, these were only automatically provisioned. And finally, as always, an improved version of the Mashup Engine is also included with the latest version, matching the July release for Power BI Desktop. This ensures that reports published and refreshed go through the same query execution logic/run-time as in the service’s latest Desktop version.
Those who have been following previous On-premises data gateway updates will recall that in April, Microsoft introduced two different installers corresponding to two different modes. Starting with the releases for that month, every month’s updates brings separate variants for each respective mode. The standard mode for the latest version can be downloaded through this link, while the personal mode is available for download here.