For example, I am connected to an Excel file and Teradata, my server can access Teradata so can refresh automatically, but the excel is stored in a local folder that the server cannot access. The Excel is static so doesn't need to be refreshed, the Teradata updates every week so needs to be refreshed every week.
I can't see a way to select which source refreshes, it's everything or nothing. So I have to do this manually and republish every time?
Thanks for any help.
Andrew Pick wrote:
... If I published that data source to the server I presume that would then solve it? I can then replace this published data source if there is ever an update.
There's two ways I think you can solve this.
1. Publish the Excel workbook to the Server as a data source as you said. This is a good idea because you only need to replace the Excel workbook in one location should it need updating.
2. Include External Files when publishing. If I understand this correctly it will capture your Excel data and keep it with the workbook AND you would still have your Teradata connection. I'll admit I'm not 100% positive about this so I would recommend testing and letting us know if it works this way or not.