Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Gateway connection with Oracle and Sharepoint data sources not working

Submitted by Anonymous on ‎10-09-2017 11:46 AM

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!!

Status: Needs Info
See more ideas labeled with:
8 Comments (8 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎10-10-2017 10:07 PM

@Anonymous

 

Are you using Table.NestedJoin function in Query Editor? If yes, the product team are looking into this issue.

 

Best Regards,
Herbert

Anonymous
Not applicable
‎10-11-2017 05:21 AM

No we are not using Table.NestedJoin function in Query Editor

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎10-11-2017 06:41 PM

@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_Song
Impactful Individual
Impactful Individual
‎10-11-2017 06:41 PM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎10-12-2017 10:56 AM

Hi Herbert,

 

Yes we just upgraded to the latest version of on-premises data gateway prior to trying to establish the gateway connection with using both Oracle and Sharepoint Online. 

grazzhopper
Frequent Visitor
‎04-19-2018 08:54 AM

We 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?

 

Anonymous
Not applicable
‎03-28-2019 01:20 PM

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.

tommuirwebb
Frequent Visitor
‎08-12-2019 07:11 AM

We are also experiencing this issue. Has there been any feedback from Microsoft on this?

Idea Statuses