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

Power BI User on 7/5/2020 10:25:43 PM

Totally agree with Cbaliliss - Personal Gateway is not a viable workaround - can Microsoft indicate where in the backlog this falls?

R

R

RE: Combine enterprise gateway and online data sources

louar139357 on 7/5/2020 10:24:51 PM

Same issues, we are using SharePoint onLine lists to handle Master Data and let end user update them when needed.

As soon as we put pbix online, refresh data doesn't works :/

R

R

RE: Combine enterprise gateway and online data sources

sadf sdf on 7/5/2020 10:23:10 PM

Hello Rflad,
I have asked Dimah to take a look at this suggestion
Thanks
Chuck

R

R

RE: Combine enterprise gateway and online data sources

Bryan Campbell on 7/5/2020 10:22:30 PM

Agreed. Enterprise connections serve larger user sets, freeing individuals up from "running dedicated personal gateways on their laptops"... But then I am limited when I get to a server, and either set up a dummy account, or force an individual to publish only from a server... Really need enterprise caught up in datasources...

R

R

RE: Combine enterprise gateway and online data sources

Matt Doherty on 7/5/2020 10:22:23 PM

This is a great idea, I'm surprised this hasn't had a greater number of votes. In our case we're using CRM Online and we want to combine it with data from our on-prem finance solution, again as @Rflad says using a common ID to combine the data. Again, as with Rflad we can create these reports in the Desktop app and upload them, but as soon as they are online the refresh stops working. Interestingly, using a personal gateway works fine, but that isn't an enterprise solution.

R

R

RE: Combine enterprise gateway and online data sources

Amadeusz Annissimo on 7/5/2020 10:21:20 PM

Have the same problem. Can't connect both MySQL and files on OneDrive when I use Enterprise Gateway. Hope this will be fixed soon.

R

R

RE: Combine enterprise gateway and online data sources

Rflad on 7/5/2020 10:19:28 PM

...., in this case SP you CAN'T benefit from the gateway......

R

R

RE: Combine enterprise gateway and online data sources

Rflad on 7/5/2020 10:19:26 PM

To be more specific, let’s say you have a common ID between Dynamics NAV on-prem and a list in SharePoint Online. You add both data sources to the same report, create a relation between the common ID and then you have a report that can reflect/filter content across both systems. The limitation I refer to above is connected to updating the dataset/report as soon as you have uploaded the content to app.powerbi.com. While working in PowerBi desktop locally on your client the update from both sources are working fine. But as soon as the report enter the “cloud” and you want to plan the update, it’s not possible. The enterprise gateway that I have created is greyed out due to the limitation mentioned above. Since the report also contain data from an online source, in this case SP you can benefit from the gateway. Not possible to enter credentials for the online source either.