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)
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.
RE: Combine enterprise gateway and online data sources
Any Update on this?
RE: Combine enterprise gateway and online data sources
Hey Admin! Whats the update on this?
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.
RE: Combine enterprise gateway and online data sources
What is soon ?????!!!!!!!
RE: Combine enterprise gateway and online data sources
What's the timeline on getting this capability on the Enterprise gateway at this point?
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.
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.).
RE: Combine enterprise gateway and online data sources
'@William, yes I meant "Not Working" :)
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.