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
It is not fixed yet. is there any plan to do it?
RE: Combine enterprise gateway and online data sources
This doesnt appear to be fixed at all...
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
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."
RE: Combine enterprise gateway and online data sources
Microsoft consegue ser incompatível com ela mesmo. Fantástico isso.
Estou com o mesmo problema.
RE: Combine enterprise gateway and online data sources
Still not resolved.
RE: Combine enterprise gateway and online data sources
Not resolved. Fix please
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.
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.
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.