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

John on 05 Jul 2020 23:19:22

RE: Combine enterprise gateway and online data sources

I agree this is hurting adoption of Power BI within our company as well. We have not yet promoted use or licenses beyond a test group. Multiple data sources are common in our reports.

Rflad's profile image Profile Picture

Heber Olimpio on 05 Jul 2020 23:19:21

RE: Combine enterprise gateway and online data sources

Bom dia!

Alguma novidade em relação a isso?

Obrigado,

Rflad's profile image Profile Picture

Anton Rozenson on 05 Jul 2020 23:19:04

RE: Combine enterprise gateway and online data sources

April gateway update had nothing to add ... disappointing - the promise date on this was Christmas 2017. Any expectations from Microsoft?

Rflad's profile image Profile Picture

Lauren on 05 Jul 2020 23:18:46

RE: Combine enterprise gateway and online data sources

I'm trying to connect SharePoint online datasets (OAuth) and a JIRA API (gateway). This is a big problem within my org, and fixing this would enable Power BI to be used more widely. With this current restriction, we have limited use cases for Power BI.

Rflad's profile image Profile Picture

Yoeri on 05 Jul 2020 23:18:19

RE: Combine enterprise gateway and online data sources

Still not functioning. Indeed using a merge queries between an on prem and online Datasource will cause the gateway not working.

Makes powerbi pretty useless for us

Rflad's profile image Profile Picture

Mudassar Riaz on 05 Jul 2020 23:17:42

RE: Combine enterprise gateway and online data sources

MS Team,
Has there been any progress, or ETA on this. Have a real ETA can at least allow people to plan things accordingly.

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:37

RE: Combine enterprise gateway and online data sources

What is the current status on this? The last news dated from Nov, almost 5 months ago?

Rflad's profile image Profile Picture

Andrew on 05 Jul 2020 23:17:28

RE: Combine enterprise gateway and online data sources

How far off is this update from happening?

Rflad's profile image Profile Picture

Anonymous on 05 Jul 2020 23:17:22

RE: Combine enterprise gateway and online data sources

Microsoft Power Bi unfortunately still a beta product. and go figure this is an outstanding issue 2 years after it was announced they'd look into it.

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:06

RE: Combine enterprise gateway and online data sources

Please make this your number one priority. It's an unacceptable limitation not being able to mix online and on-premise sources. I'm quite flabbergasted this is still an issue.