Forum Discussion
Scheduled data refresh mapped drive
'm building query to bring all files from a specific folder. I came across the issue of file max length. I worked around the solution to map that folder to a drive(i.e G:\). The problem that I would...
d_gosbell
Super User
Super UserThe problem here is that mapped drives only exist in the context of a user session. So you have a G: drive on your machine, but when the Report Server service account runs it does not have a G: drive. You need to use a UNC path (eg. \\server\share\folder1\folder2 ) if you want the scheduled refresh to work on the Report Server. If the path is too long you might need to ask your IT department if they can create a share lower down in the folder hierarchy for you.