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

William on 05 Jul 2020 23:09:46

RE: Combine enterprise gateway and online data sources

Jean-Pierre did you mean not working right?
Not working: SharePoint Folder (excel file) and MySQL On-Premises (into separated queries)

Rflad's profile image Profile Picture

Jean-Pierre Riehl on 05 Jul 2020 23:09:32

RE: Combine enterprise gateway and online data sources

Just to add my results to those provided by Helge :

Note working : SharePoint Folder (excel file) and MySQL On-Premises (into separated queries)

Rflad's profile image Profile Picture

Rob on 05 Jul 2020 23:09:16

RE: Combine enterprise gateway and online data sources

Status update?

Rflad's profile image Profile Picture

Jo-Anne on 05 Jul 2020 23:08:57

RE: Combine enterprise gateway and online data sources

Is this going to include a fix to merging different sources, both on prem, and that causing the gateway to be unavailable?

Rflad's profile image Profile Picture

Helge on 05 Jul 2020 23:08:43

RE: Combine enterprise gateway and online data sources

'We tested the new version of the Enterprise Gateway and the improvements. Please find below our results:

Working:
- Create a dataset with a mixture of cloud and on prem data sources, e.g. SharePoint Online and SQL on Prem

Not Working (Enterprise Gateway is greyed out):
- A combination of cloud and on prem data sources in a query, e.g. Source = Table.Combine({OnPremQueryResult, CloudQueryResult})

Sidenote
- A dataset which uses the Azure Consumptions Insights connector in combination with any on Prem Datasource, even if there is no combination among theses queries (this works if you do not use the Azure Consumptions Insights connector).

Thank you for fixing the combination issue as soon as possible.

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:07:08

RE: Combine enterprise gateway and online data sources

Any update on this?

Rflad's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:06:33

RE: Combine enterprise gateway and online data sources

I have experienced the same thing as Mike Honey in the oil and gas industry. Our users were very excited to be able to use the Enterprise Gateway for combining on-prem and cloud sources but then without data-mashup they said what is the point. I hope you guys continue to make progress in this regard since we have 100's of users who are still waiting.

Rflad's profile image Profile Picture

Mike Honey on 05 Jul 2020 23:06:10

RE: Combine enterprise gateway and online data sources

It looks like this has missed the November release, ref https://powerbi.microsoft.com/en-us/blog/on-premises-data-gateway-november-update-is-now-available/

It's frustrating as there was lot's of other functionality added, which all seems edge/niche use cases. I estimate this mashup issue trips up and frustrates hundreds of users every day - they build something that seems fine in PBI Desktop, then can't use the gateway to refresh.

Rflad's profile image Profile Picture

Lazar on 05 Jul 2020 23:06:09

RE: Combine enterprise gateway and online data sources

It is possible to combine data sources from both online sources and on-prem using on-premises data gateway (personal mode). I have never tried enterprise solution but in my opinion doesn't make sense if enterprise version can't complete what on-premises data gateway (personal mode) can.

Rflad's profile image Profile Picture

efi goldman on 05 Jul 2020 23:05:56

RE: Combine enterprise gateway and online data sources

Thanks. how soon?