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
Charles, I am still not able to refresh the file in PowerBI.com. I have not mashed up the data. Do you have any instructions or documentation? Do I need to update PowerBI Desktop or the Gateway?
RE: Combine enterprise gateway and online data sources
Why is this completed when only Phase 1 is done. Where is Phase 2 to vote on?
RE: Combine enterprise gateway and online data sources
While we are still working on this I am marking it as completed as Phase 1 for this feature has been released. All you need to do is make sure they have configured the on-prem source(s) in the OPDG and also provided credentials for the cloud-based sources in the Dataset Refresh Settings page. You should be able to refresh the dataset (as long as you are not mashing up data from these sources)
RE: Combine enterprise gateway and online data sources
Do we need an updated gateway? The one in the download center is still from Sept 2017.
RE: Combine enterprise gateway and online data sources
It worked! Awesome!
RE: Combine enterprise gateway and online data sources
Any update on mash up data?
RE: Combine enterprise gateway and online data sources
It looks like this has been implemented. Previously for an on-premise/online mixed data source, the enterprise gateway was greyed out. It is now active and I am running a refresh.
RE: Combine enterprise gateway and online data sources
'@Ari timonen, can you explain how you managed to set up datasource is gateway.
RE: Combine enterprise gateway and online data sources
I have managed to setup refresh for a report combining data from on-premise SQL server and Excel-sheets hosted in Sharepoint.
So this seems to be implemented even though there's no confirmation from Microsoft.
RE: Combine enterprise gateway and online data sources
Hi Team/Community,
is there any update on this. Still under progress, or already implemented.