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

Power BI User on 05 Jul 2020 22:57:06

RE: Combine enterprise gateway and online data sources

Any feedback on this? Thanks

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:57:05

RE: Combine enterprise gateway and online data sources

We spent quite a few hours on modifying SharePoint team site type, access rights, gateway authentication methods, ... because the gateway UI throws an authentication exception.
I might have cursed Microsoft and wished corporate bankruptcy upon them in a weak moment also...
HOWEVER: Get this fixed and - as usual - joy and tranquility will replace despair and frustration.
What is a (corporate) on premises data gateway if not a gateway to all our on premises + online data sources?? Kind regards, Inge V

Rflad's profile image Profile Picture

Karl Larsson on 05 Jul 2020 22:56:47

RE: Combine enterprise gateway and online data sources

Just adding my voice to the need to allow cloud and on premises data to mix via the enterprise gateway. O365 Sharepoint and SQL in my case.

Rflad's profile image Profile Picture

Pieter Muller on 05 Jul 2020 22:56:36

RE: Combine enterprise gateway and online data sources

Hi, the gateway update for August has been released. However, the same issue appears. Both by executing the gateway install via Power BI portal or via this official communication: https://powerbi.microsoft.com/en-us/blog/power-bi-on-premises-data-gateway-august-update/ . Any feedback on this?

Rflad's profile image Profile Picture

Abduvali on 05 Jul 2020 22:56:30

RE: Combine enterprise gateway and online data sources

Allowing on-premises gateway to combine with on-premises data source is a must have feature!!!

Rflad's profile image Profile Picture

Rob Durrant on 05 Jul 2020 22:56:18

RE: Combine enterprise gateway and online data sources

Hi Miguel, Is this still on track for end of August 2017?

Rflad's profile image Profile Picture

Aaron Steers on 05 Jul 2020 22:56:14

RE: Combine enterprise gateway and online data sources

Will this include OAuth authentication support for SharePoint data files?

We need this for Excel data stored in O365, aka OneDrive for Business.

Rflad's profile image Profile Picture

salty_sea_dog on 05 Jul 2020 22:55:01

RE: Combine enterprise gateway and online data sources

Will this also mean Azure Analysis Services won't require a separate gateway installation?

Rflad's profile image Profile Picture

Mark on 05 Jul 2020 22:54:58

RE: Combine enterprise gateway and online data sources

Fantastic news Miguel.

I genuinely believe if this features deliveries on our expectations, this would make PowerBI one of the best tools in the world! I've previously praised Microsoft's efforts on this product both to your team and the wider business world but it has been lacking this tiny feature for some time which has stopped it from being used by most organisations efficiently and effectively.

Bring on the update and some champagne!

Rflad's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:54:53

RE: Combine enterprise gateway and online data sources

Excellent ! Thanks Miguel