Skip to main content
Microsoft Idea

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

Ellie on 05 Jul 2020 23:00:13

RE: Combine enterprise gateway and online data sources

Any update?

Rflad's profile image Profile Picture

Rob Durrant on 05 Jul 2020 23:00:12

RE: Combine enterprise gateway and online data sources

Let's have an update please.

Rflad's profile image Profile Picture

Darran on 05 Jul 2020 23:00:02

RE: Combine enterprise gateway and online data sources

Has this arrived as at 28/09/2017?

Rflad's profile image Profile Picture

David H on 05 Jul 2020 22:59:57

RE: Combine enterprise gateway and online data sources

Any updates Miguel as we near the end of September?

Rflad's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:59:26

RE: Combine enterprise gateway and online data sources

Please, make possible to have oData and SQL queries in the same dataset, using only on-prem data gateway (old enterprise gateway). This will be available in the next update (end of September) ?

Rflad's profile image Profile Picture

Rob Durrant on 05 Jul 2020 22:59:23

RE: Combine enterprise gateway and online data sources

Desperately need this feature! Its hard to imagine this functionality without mash-up of prem vs cloud sources. Seems like they are having difficulty getting this done.

Rflad's profile image Profile Picture

efi goldman on 05 Jul 2020 22:59:23

RE: Combine enterprise gateway and online data sources

frustrating...

Rflad's profile image Profile Picture

James on 05 Jul 2020 22:58:56

RE: Combine enterprise gateway and online data sources

It is really hard to have this talked about as a "feature" of a future release when in fact it used to work.

Rflad's profile image Profile Picture

edh on 05 Jul 2020 22:58:14

RE: Combine enterprise gateway and online data sources

Great to hear it is still being worked on. Honestly though, hard to imagine a scenario where things aren't mashed up.

Rflad's profile image Profile Picture

Rflad on 05 Jul 2020 22:57:54

RE: Combine enterprise gateway and online data sources

Hi great to see some progress, looking forward to being able to accumulate values from "different" sources in a stacked column chart.