Forum Discussion
Schedule Refresh with Multiple Data Sources (Oracle & Excel)
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
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
2 Replies
- v-jiascu-msftMicrosoft Employee
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
- v-jiascu-msftMicrosoft Employee
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