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

    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.