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

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

Comments

R

It does not support merge/append, but I guess it supports creating relations between the sources?

R

Any update? I have a critical item that depends on that for going to production

R

Updates on this, please? Greatly needed :) :) :)

R

Any updates? Pleeeeeease!
Thanks!

R

This looks like the answer to our prayers. You can now schedule refreshes via gateway for queries that perform a merge or append query using a cloud and on-prem source:

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

R

Mine is working fine on the Gateway from a while too, I have a on Prem SQL Date Source and a SharePoint list in one and in the other I have Excel Online.

R

Can we get an update on this?

R

Power BI is not a viable option for us without an online datasource too. Hey Microsoft! Please help!!

R

This has already been completed, hasn't it? We've been mashing up on-prem and online data sources for months now...

R

Getting really sick of Microsoft promoting and advancing new tech (Teams, Azure advancements, AI, etc) when a boatload of old tech doesn't work at all or is severely lacking in functionality compared to competitors.
Please commit to the deadlines you set for yourselves. We do. Most everyone else does too.