Skip to main content
Microsoft Idea

Power BI

Completed

Combine enterprise gateway and online data sources

Vote (1304) Share
Rflad's profile image

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)
Rflad's profile image Profile Picture

Mike Honey on 05 Jul 2020 22:57:52

RE: Combine enterprise gateway and online data sources

I'm a bit baffled by the difficulties producing a gateway with complete functionality - surely it should just be a windowless version of the Power BI Desktop Query engine, triggered remotely?

Miguel's latest update sounds more like they are re-inventing the wheel ...

Rflad's profile image Profile Picture

Miguel Llopis on 05 Jul 2020 22:57:51

RE: Combine enterprise gateway and online data sources

'@Zachary - That is currently possible when using Import mode for SSAS, not with Live Mode. This scenario does not cover expanding capabilities for Live SSAS mode, but rather it ensures that the scenarios that are already possible in Power BI Desktop today work via the Gateway for refresh purposes.

Rflad's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 22:57:44

RE: Combine enterprise gateway and online data sources

Will the 2nd phase mash-up capabilities include the ability to blend SSAS tabular data models with on-premise data and/or online data sources as well?

Rflad's profile image Profile Picture

Alex D on 05 Jul 2020 22:57:41

RE: Combine enterprise gateway and online data sources

Yes thank you for the follow-up. Very appreciated.

Rflad's profile image Profile Picture

SergeiStPete on 05 Jul 2020 22:57:41

RE: Combine enterprise gateway and online data sources

Thanks for the update Miguel, will wait...

Rflad's profile image Profile Picture

San on 05 Jul 2020 22:57:41

RE: Combine enterprise gateway and online data sources

Hi Miguel Llopis, I see that you mentioned the current ETA as end of August. Is there any change in the release date. As it is end of august now and we do not see the new version of gateway that is supporting this feature

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:57:29

RE: Combine enterprise gateway and online data sources

any updates would be greatly appreciated

Rflad's profile image Profile Picture

Felipe Girado on 05 Jul 2020 22:57:18

RE: Combine enterprise gateway and online data sources

Is this feature coming out this week?

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:57:10

RE: Combine enterprise gateway and online data sources

Desperately want this feature! Looking forward to seeing it available.

Rflad's profile image Profile Picture

Power BI User on 05 Jul 2020 22:57:09

RE: Combine enterprise gateway and online data sources

Is there any update on this? Thank you!