Skip to main content

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

Raul Torres on 29 Mar 2023 15:46:10

RE: Combine enterprise gateway and online data sources

It is not fixed yet. is there any plan to do it?

Rflad's profile image Profile Picture

Keegan Ross on 29 Oct 2021 17:25:05

RE: Combine enterprise gateway and online data sources

This doesnt appear to be fixed at all...

Rflad's profile image Profile Picture

David Hajdu on 21 May 2021 04:52:01

RE: Combine enterprise gateway and online data sources

Still does not work with steps in link: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud

Rflad's profile image Profile Picture

Martin Bønnelykke Jensen on 17 Jul 2020 09:53:36

RE: Combine enterprise gateway and online data sources

I guess noone reads these commets anyway, but i have the exact same problem as Rflad describes. And because of that you need to not consider this as "Completed". Who do i need to contact to actually do something?

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."

Rflad's profile image Profile Picture

Lucas on 06 Jul 2020 00:17:53

RE: Combine enterprise gateway and online data sources

Microsoft consegue ser incompatível com ela mesmo. Fantástico isso.
Estou com o mesmo problema.

Rflad's profile image Profile Picture

Power BI User on 06 Jul 2020 00:15:30

RE: Combine enterprise gateway and online data sources

Still not resolved.

Rflad's profile image Profile Picture

Deepa on 06 Jul 2020 00:10:42

RE: Combine enterprise gateway and online data sources

Not resolved. Fix please

Rflad's profile image Profile Picture

Denise Hawkins on 06 Jul 2020 00:10:33

RE: Combine enterprise gateway and online data sources

Still needing to mix data from online Sharepoint and SQL server and not able to. Please add.

Rflad's profile image Profile Picture

Deepa on 06 Jul 2020 00:07:37

RE: Combine enterprise gateway and online data sources

It is not resolved. Please fix this. Establishing connection between Enterprise Gateway and Cloud-based data sources at the same time is a must.

Rflad's profile image Profile Picture

jawad on 05 Jul 2020 23:59:54

RE: Combine enterprise gateway and online data sources

As of recently I am still having this problem. However, I've found a workaround by utilizing dataflows for the sharepoint part.

In my case I am combining data from SSAS Tabular Database with an Excel file in Sharepoint.

Here are the steps approximately:

1) For the Excel on Sharepoint, I created a dataflow to read the Excel by providing the path/URL to the Excel File. No gateway is selected.

2) In Power Query (Desktop), I created a query for my SSAS database which is on premise (gateway required). Then I created another query where the source is my dataflow that I created in step 1.

3) I published my dataset/report

4) The refresh worked.



Another thing to note here is to make sure you have the most recent gateway installed. This is because the dataflow feature is relatively new in Power BI Service and since you want to use the dataflow as a source in PowerBI you need to make sure you have the most recent gateway installed or at least the one that support connecting to a dataflow from Power Query Desktop.