It is not fixed yet. is there any plan to do it?
This doesnt appear to be fixed at all...
Still does not work with steps in link: https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud
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."
Microsoft consegue ser incompatível com ela mesmo. Fantástico isso.
Estou com o mesmo problema.
Still not resolved.
Not resolved. Fix please
Still needing to mix data from online Sharepoint and SQL server and not able to. Please add.
It is not resolved. Please fix this. Establishing connection between Enterprise Gateway and Cloud-based data sources at the same time is a must.
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.
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