Skip to main content

Power BI

Completed

Combine enterprise gateway and online data sources

Vote (1304) Share
Rflad's profile image

Rflad on 13 Apr 2016 16:08:02

At this time, a gateway will not function properly if you are using data sources and one is online and one is on-prem. As soon as the online data source is added, the gateway is designed to gray out because Power BI interprets that it is no longer needed. I would like to be able to combine data sources from both on-prem and online sources together with the use of gateways.

Administrator on 25 Apr 2023 23:33:37

Was finished a while back...marking as finished https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

Comments (238)
Rflad's profile image Profile Picture

Nathan Loehrs on 05 Jul 2020 23:01:52

RE: Combine enterprise gateway and online data sources

Charles, I am still not able to refresh the file in PowerBI.com. I have not mashed up the data. Do you have any instructions or documentation? Do I need to update PowerBI Desktop or the Gateway?

Rflad's profile image Profile Picture

Rob Durrant on 05 Jul 2020 23:01:52

RE: Combine enterprise gateway and online data sources

Why is this completed when only Phase 1 is done. Where is Phase 2 to vote on?

Rflad's profile image Profile Picture

sadf sdf on 05 Jul 2020 23:01:50

RE: Combine enterprise gateway and online data sources

While we are still working on this I am marking it as completed as Phase 1 for this feature has been released. All you need to do is make sure they have configured the on-prem source(s) in the OPDG and also provided credentials for the cloud-based sources in the Dataset Refresh Settings page. You should be able to refresh the dataset (as long as you are not mashing up data from these sources)

Rflad's profile image Profile Picture

edh on 05 Jul 2020 23:01:50

RE: Combine enterprise gateway and online data sources

Do we need an updated gateway? The one in the download center is still from Sept 2017.

Rflad's profile image Profile Picture

Marcela Miranda Melo on 05 Jul 2020 23:01:50

RE: Combine enterprise gateway and online data sources

It worked! Awesome!

Rflad's profile image Profile Picture

J the WeatherMAN on 05 Jul 2020 23:01:43

RE: Combine enterprise gateway and online data sources

Any update on mash up data?

Rflad's profile image Profile Picture

Steve Nakano on 05 Jul 2020 23:01:11

RE: Combine enterprise gateway and online data sources

It looks like this has been implemented. Previously for an on-premise/online mixed data source, the enterprise gateway was greyed out. It is now active and I am running a refresh.

Rflad's profile image Profile Picture

Arun on 05 Jul 2020 23:01:08

RE: Combine enterprise gateway and online data sources

'@Ari timonen, can you explain how you managed to set up datasource is gateway.

Rflad's profile image Profile Picture

Ari Timonen on 05 Jul 2020 23:00:53

RE: Combine enterprise gateway and online data sources

I have managed to setup refresh for a report combining data from on-premise SQL server and Excel-sheets hosted in Sharepoint.

So this seems to be implemented even though there's no confirmation from Microsoft.

Rflad's profile image Profile Picture

Mudassar Riaz on 05 Jul 2020 23:00:50

RE: Combine enterprise gateway and online data sources

Hi Team/Community,

is there any update on this. Still under progress, or already implemented.