On-premises data gateway February update is now available

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

You are now able to refresh queries combining data from on-premises and cloud data sources.

Improvements to the gateway support for DirectQuery over SAP HANA (preview).

The on-premises data gateway now includes the February version of the mashup engine.

You can download this new version from the link below and continue reading for more details about each enhancement.

Important Note

Before we start talking about this month’s improvements, we wanted to reminder you that on March 15th, our support to on-premises data gateway versions that are older than the August 2017 release will end.

We always recommend staying up to date with new releases but if you are using a release that is older than the August 2017 release, please upgrade to a newer version to ensure no disruptions to the gateway functionality.

Please refer to our documentation here for more details and the reasons behind this change.

Now onto this month’s enhancements

Combining on-premises and cloud data sources

This has been the top gateway ask from the community on our ideas website.

Last year we enabled the ability to refresh Power BI Desktop files that retrieve on-premises data and cloud data in separate queries. A huge ask remained to enable the ability to merge or append data from those sources in the same query. We have been working on enabling that and we are happy to announce that you are able to do this now.

Here is a quick guide on how to do that:

After installing on-premises data gateway, go to the “Manage gateways” page and select the gateway you want to use.

Under Gateway Cluster Settings, you’ll see a new checkbox that says “Allow user’s cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster”, make sure this box is checked (currently it is not checked by default).

Add any on-premises data sources you are using in your queries under this gateway cluster as you do normally. You do not need to add the cloud data sources you are using in your queries.

Upload the Power BI Desktop file that has the queries that combine the on-premises and the cloud data sources to the Power BI service.

Got to the dataset settings page for the new dataset. You’ll notice the following:

For the on-premises source, you can pick the gateway that has this source defined like you normally do.

For the cloud source, you will be able to edit its credentials under “Data source credentials” as you normally do with any other cloud source.

Once the cloud credentials are set, you can now refresh the dataset using the Refresh now option or schedule it to refresh periodically.

Improvements to the gateway support for DirectQuery over SAP HANA

Earlier this month, with the February release of Power BI Desktop, we announced improvements to DirectQuery over SAP HANA connectivity particularly around treating SAP HANA as a multi-dimensional source by default.

With this month’s gateway release, Power BI Desktop reports using that improved SAP HANA DirectQuery connector can be used with the on-premises data gateway as well.

For more details on how to use this new improved SAP HANA DirectQuery connector in Power BI Desktop, please check our announcement earlier this month as well as our SAP HANA DirectQuery connectivity documentation.

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.

Sign up for the Power BI Newsletter

Sign up below to get the latest from Power BI, direct to your inbox!

By clicking Sign up today, you are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. You can unsubscribe at any time. Microsoft Privacy Statement.

What is Power BI?

Power BI is a suite of business analytics tools to analyze data and share insights. Monitor your business and get answers quickly with rich dashboards available on every device.