Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Auto/ Schedule Refresh for Excel based data source on report server.

Hi Guys,    Wanted to check if there is any way by refersh the excel based data source reports on report server?   Currently we download the report first and then refersh the in Power Bi Desktop ...
Report Server
  • Icey's avatar
    Icey
    5 years ago

    Hi Anonymous ,

     

    Just as what d_gosbell mentioned, if a File or Folder data source is used and the file path is a local path (e.g. C:\Users\user\Documents), then a refresh plan cannot be created. The path must be a path the report server can connect to like a network share. For example, \myshare\Documents.

     

    For sharing a fileover a network in Windows 10, please refer: File sharing over a network in Windows 10 (microsoft.com). Then you can set scheduled refresh for reports.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Community Support
5 years ago

Hi Anonymous ,

 

Just as what d_gosbell mentioned, if a File or Folder data source is used and the file path is a local path (e.g. C:\Users\user\Documents), then a refresh plan cannot be created. The path must be a path the report server can connect to like a network share. For example, \myshare\Documents.

 

For sharing a fileover a network in Windows 10, please refer: File sharing over a network in Windows 10 (microsoft.com). Then you can set scheduled refresh for reports.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.