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

Domus Social on 05 Jul 2020 22:37:02

RE: Combine enterprise gateway and online data sources

Any updates on this? Huge roadblocker for us... Need to combine DW data (SQL Server) with budgeting w/ excel files on OneDrive for Business.

Rflad's profile image Profile Picture

Alby on 05 Jul 2020 22:36:44

RE: Combine enterprise gateway and online data sources

I completely agree: to adopt PBI in large organizations this is a must have feature!

Rflad's profile image Profile Picture

Brian brian.pitera@owenscorning.com on 05 Jul 2020 22:36:33

RE: Combine enterprise gateway and online data sources

I'm also trying to combine data from CRM online with an on-prem SQL database.... I need this feature to be able to refresh data.

Rflad's profile image Profile Picture

Szilard Szankovics on 05 Jul 2020 22:36:18

RE: Combine enterprise gateway and online data sources

Please make this happen. The current situation causes much trouble, this is needed badly.

Rflad's profile image Profile Picture

Paul on 05 Jul 2020 22:36:03

RE: Combine enterprise gateway and online data sources

Please! Having multiple gateway's a pain.

Rflad's profile image Profile Picture

Jeppe on 05 Jul 2020 22:36:02

RE: Combine enterprise gateway and online data sources

Agreed, this is a must have feature!

Why can I add online sources to on-prem Gateway in "Manage Gateways" if they are not supported?

Rflad's profile image Profile Picture

Russell on 05 Jul 2020 22:35:58

RE: Combine enterprise gateway and online data sources

seriously! when is this getting fixed?

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:35:04

RE: Combine enterprise gateway and online data sources

This feature should have been implemented from day one as I suppose that this marked to enterprise customers.

Rflad's profile image Profile Picture

Luc Schauvaerts on 05 Jul 2020 22:34:30

RE: Combine enterprise gateway and online data sources

This is not a improvement, it is fixing a major problem!
Already stated:
This is a major problem, trying to combine Dynamics online with an on prem SQL database and it's not possible. One of the key selling points of the product is being able to combine data sources and this is just not possible. Please fix!

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:33:38

RE: Combine enterprise gateway and online data sources

Some online data sources do work. I can connect to an Acumatica O-Data feed and Excel files on my laptop using the Data Gateway but cannot get Saleforce.com and Excel files on my laptop to work. The problem, in my case, appears to be the link to Salesforce.com.