1303
R

Combine enterprise gateway and online data sources

Rflad on 4/13/2016 4:08:02 PM
1303
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.
STATUS DETAILS
Completed

Administrator on 4/25/2023 11:33:37 PM

Was finished a while back...marking as finished https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

Comments

R

R

RE: Combine enterprise gateway and online data sources

Ryan Power BI User on 7/5/2020 11:13:41 PM

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

R

R

RE: Combine enterprise gateway and online data sources

Georg on 7/5/2020 11:13:39 PM

Any Update on this?

R

R

RE: Combine enterprise gateway and online data sources

Power BI User on 7/5/2020 11:13:08 PM

Hey Admin! Whats the update on this?

R

R

RE: Combine enterprise gateway and online data sources

Josiah on 7/5/2020 11:12:26 PM

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.

R

R

RE: Combine enterprise gateway and online data sources

Power BI Ideas Admin on 7/5/2020 11:12:14 PM

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

R

R

RE: Combine enterprise gateway and online data sources

Jeremy on 7/5/2020 11:11:26 PM

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

R

R

RE: Combine enterprise gateway and online data sources

Power BI User on 7/5/2020 11:11:05 PM

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.

R

R

RE: Combine enterprise gateway and online data sources

Jean-Pierre Riehl on 7/5/2020 11:10:27 PM

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.).

R

R

RE: Combine enterprise gateway and online data sources

Jean-Pierre Riehl on 7/5/2020 11:10:22 PM

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

R

R

RE: Combine enterprise gateway and online data sources

Power BI User on 7/5/2020 11:10:03 PM

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.