Schedule Refresh with Multiple Data Sources (Oracle & Excel)

[blackshep01]

Hello! I have a dataset that has Excel and Oracle in it. I have Oracle setup on the On-Prem Data Gateway. How do I setup the Excel with the data gateway? I want to schedule a refresh for this data source.  And, yes, I do have the On-Prem Data Gateway installed.

Dataset

---------------------------------------------------------------------------------------------

Manage Gateway: Oracle

[v-jiascu-msft]

Hi @blackshep01,

Could you please mark the proper answer if it's convenient for you? That will be a help to others.

Best Regards!
Dale

[v-jiascu-msft · Accepted solution]

Hi @blackshep01,

We should choose "Use a data gateway" due to the first option is a personal gateway. (In your first picture). And then we add new data source. The "data source type" is "file". "full path" is FULL path.

Best Regards!

Dale