1 of 1 people found this helpful
Since Shape file is manual file you need publish the workbook with some precautions
1) While publish Include external files uncheck it
1) Place the file in Network Drive
2) Provide the access to the file for "Run AS User"
whenever the extract run it will fetch the data
This solved the problem. Such a small thing to overlook making a large pain in my side
Thank you so much for your help.
Glad it helped
Have a nice day