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

Rflad on 05 Jul 2020 23:23:55

RE: Combine enterprise gateway and online data sources

It does not support merge/append, but I guess it supports creating relations between the sources?

Rflad's profile image Profile Picture

Bruno Ferreira on 05 Jul 2020 23:23:51

RE: Combine enterprise gateway and online data sources

Any update? I have a critical item that depends on that for going to production

Rflad's profile image Profile Picture

James Houck on 05 Jul 2020 23:22:36

RE: Combine enterprise gateway and online data sources

Updates on this, please? Greatly needed :) :) :)

Rflad's profile image Profile Picture

Michael Shparber on 05 Jul 2020 23:22:34

RE: Combine enterprise gateway and online data sources

Any updates? Pleeeeeease!
Thanks!

Rflad's profile image Profile Picture

Scott Brier on 05 Jul 2020 23:22:09

RE: Combine enterprise gateway and online data sources

This looks like the answer to our prayers. You can now schedule refreshes via gateway for queries that perform a merge or append query using a cloud and on-prem source:

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

Rflad's profile image Profile Picture

Jai nirvana_moksh on 05 Jul 2020 23:22:05

RE: Combine enterprise gateway and online data sources

Mine is working fine on the Gateway from a while too, I have a on Prem SQL Date Source and a SharePoint list in one and in the other I have Excel Online.

Rflad's profile image Profile Picture

Tim Smith on 05 Jul 2020 23:21:58

RE: Combine enterprise gateway and online data sources

Can we get an update on this?

Rflad's profile image Profile Picture

Anonymous on 05 Jul 2020 23:21:40

RE: Combine enterprise gateway and online data sources

Power BI is not a viable option for us without an online datasource too. Hey Microsoft! Please help!!

Rflad's profile image Profile Picture

Tobias Owen on 05 Jul 2020 23:21:18

RE: Combine enterprise gateway and online data sources

This has already been completed, hasn't it? We've been mashing up on-prem and online data sources for months now...

Rflad's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:21:06

RE: Combine enterprise gateway and online data sources

Getting really sick of Microsoft promoting and advancing new tech (Teams, Azure advancements, AI, etc) when a boatload of old tech doesn't work at all or is severely lacking in functionality compared to competitors.
Please commit to the deadlines you set for yourselves. We do. Most everyone else does too.