Scheduled data refresh mapped drive

[Anonymous]

'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?

[d_gosbell]

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.