topic How to use uploaded Excel sheets in a report on the server? in Report Server

How to use uploaded Excel sheets in a report on the server?

Anonymous — Tue, 14 Sep 2021 06:23:37 GMT

Hi,

I am using the PB Report Server. Normally I build my reports on my desktop in the PBRS Desktop App. After finishing I upload the report via the web interface to the server. But now I used a Excel sheet in the report, which lays on my local Desktop in the report. How can I use this sheet on the server too?

I thought, if I am uploading this sheet to the report server via the web interface that I then could change the file path within the report to the uploaded sheet but there is no way to change those paths. Any tips?

Thanks a lot.

Re: How to use uploaded Excel sheets in a report on the server?

Icey — Thu, 16 Sep 2021 10:09:11 GMT

Hi Anonymous ,

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.

Reference: Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs

You can share files in File Explorer on Windows 10 like so:

Best Regards,

Icey

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