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 wouldn't be able to use the schedule refresh & got the following message instead:
Scheduled data refresh is unavailable for files not mapped to a network drive path.
How to overcome this problem?
1 Reply
The 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.
