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

Ryan Power BI User on 05 Jul 2020 23:13:41

RE: Combine enterprise gateway and online data sources

Update please? Posted in 2016 and still an issue... we are using a PBI report using on prem SQL and SharePoint Online data.

Rflad's profile image Profile Picture

Georg on 05 Jul 2020 23:13:39

RE: Combine enterprise gateway and online data sources

Any Update on this?

Rflad's profile image Profile Picture

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

RE: Combine enterprise gateway and online data sources

Hey Admin! Whats the update on this?

Rflad's profile image Profile Picture

Josiah on 05 Jul 2020 23:12:26

RE: Combine enterprise gateway and online data sources

what does the timeline look like for this? Tried to schedule a refresh for a report combining an on-prem SQL data source and a Salesforce data source and could not.

Rflad's profile image Profile Picture

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

RE: Combine enterprise gateway and online data sources

What is soon ?????!!!!!!!

Rflad's profile image Profile Picture

Jeremy on 05 Jul 2020 23:11:26

RE: Combine enterprise gateway and online data sources

What's the timeline on getting this capability on the Enterprise gateway at this point?

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:11:05

RE: Combine enterprise gateway and online data sources

I am running Gateway version 14.16.6584.1. I can mash up SharePoint Online Folders on the Enterprise. But, I cannot mashup SharePoint Online Lists on Enterprise Gateway when I added the Lists to the same pbix Dataset. However, I *can* run the combined SharePoint Online, List, and on prem SQL Server mashups using Personal Gateway. I assume the SharePoint List mashup capability is a feature that is coming soon.

Rflad's profile image Profile Picture

Jean-Pierre Riehl on 05 Jul 2020 23:10:27

RE: Combine enterprise gateway and online data sources

With latest Gateway version (14.16.6584.1 - 23/01/2018), I am able to refresh my hybrid model with MySQL data and SharePoint Online Excel file.
2 sources are separated (no merge, union, etc.).

Rflad's profile image Profile Picture

Jean-Pierre Riehl on 05 Jul 2020 23:10:22

RE: Combine enterprise gateway and online data sources

'@William, yes I meant "Not Working" :)

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 23:10:03

RE: Combine enterprise gateway and online data sources

I am curious about this... I had mashed up on prem SQL data and Excel files stored in sharepoint. No way to keep it up to date using the enterprise gateway, correct? I am testing a personal gateway today to see what will happen.