Gateway connection with Oracle and Sharepoint data sources not working
We're trying to schedule gateway refresh for a dataset in Service that is connecting to our Oracle database and Excel files on SharePoint Online. Separately, we can refresh the data on both of these data sources. (i.e. we have installed and configured the gateway to our Oracle data warehouse.)
The problem we're having is when both of these sources are combined into one dataset, we're unable to schedule the refresh. Is there a way to establish a Gateway connection with two different sources, Oracle and Sharepoint?
Hopefully we're just doing something wrong that this isn't a limitation of the Gateway. Please let us know. Thanks!!
8 Comments
v-haibl-msftMicrosoft Employee
Anonymous
Are you using Table.NestedJoin function in Query Editor? If yes, the product team are looking into this issue.
Best Regards,
Herbert- v-haibl-msft
Anonymous
Are you using the latest version of on-premises data gateway. According to the comments in this related idea, this scenario should work well with latest gateway release.
Best Regards,
Herbert 
Vicky_SongImpactful Individual
Status changed:NewtoNeeds InfoWe seem to have the same issue. A simultaneous PowerBI connection through an On Premise DataGateway with our Oracle datase in conjunction with a connection to an Excelsheet on Sharepoint properly configured through the Sharepoint Connector in the PowerBI desktop Navigator with the right credentials does not seem possible once published to the PowerBI cloud.
It works in the PowerBI Desktop without problems.
Unless the connection to the Excelsheet on the Sharepoint location should also be directed through the On Premise DataGateway I don't see why the uploaded report complains about not being able to connect to the Datagateway for the Oracle connection.
Were there any updates to this issue?
Is there any update on this issue?
I am also facing a similar issue. In Power BI service, I could only refresh my report which uses Oracle and SharePoint data sources using my personal gateway, it doesn't allow me to select On-premise gateway. With other reports, the on-premise gateway works totally fine.
We are also experiencing this issue. Has there been any feedback from Microsoft on this?
