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

Ismael Umpierrez on 05 Jul 2020 23:16:55

RE: Combine enterprise gateway and online data sources

vamo arriba!

Rflad's profile image Profile Picture

Jonathan on 05 Jul 2020 23:16:48

RE: Combine enterprise gateway and online data sources

I'm so confused about what works and what doesn't work yet with this. I have one report that works, the other one doesn't work with the gateway.

Rflad's profile image Profile Picture

Christiaan Basson on 05 Jul 2020 23:15:57

RE: Combine enterprise gateway and online data sources

When will we be able to use full mashup capability (planned for late 2017)?

Rflad's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:15:41

RE: Combine enterprise gateway and online data sources

Can you please provide an estimated delivery date?

Rflad's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:14:51

RE: Combine enterprise gateway and online data sources

Any update on this please?

Rflad's profile image Profile Picture

Chris Hawkins on 05 Jul 2020 23:14:41

RE: Combine enterprise gateway and online data sources

Really need an update on this!

Rflad's profile image Profile Picture

Gustav Palsson on 05 Jul 2020 23:14:32

RE: Combine enterprise gateway and online data sources

Soon (TM) since nov 2017.
This is a major problem.

Rflad's profile image Profile Picture

Jesper Barslund on 05 Jul 2020 23:14:14

RE: Combine enterprise gateway and online data sources

To confirm, will the recent gateway update enable me to combine data from on-prem SQL and online Google Analytics data (OAuth2 login)

?

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:13:49

RE: Combine enterprise gateway and online data sources

Unbelievable that this is still not working yet. I think it is a major requirement to combine on-premises datasources and online datasources using an enterprise gateway.

Rflad's profile image Profile Picture

Dominic Bristow on 05 Jul 2020 23:13:42

RE: Combine enterprise gateway and online data sources

We too have this issue. Currently trying to combine a local MySQL DB link with some online resources and coming up against numerous issues.

Most recently, one of your technicians suggested I move from using OneDrive files (which ARE recognised by the gateway) to data in a Sharepoint list, but it now throws an error saying credentials are not right...

We are trying to get the online file to work as an input to an 'invoke custom function'. Should be straightforward, but it's being a nightmare.