Forum Discussion

blackshep01's avatar
blackshep01
Frequent Visitor
9 years ago
Solved

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-msft's avatar
    v-jiascu-msft
    Microsoft 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-msft's avatar
    v-jiascu-msft
    Microsoft 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