Forum Discussion
Scheduled data refresh for local excel file
Hello,
I'm using Power BI Report Server October 2017 on a virtual machine and I'm using as a data source for the moment just a local excel file.
I update the excel every day and I want to set up the Power BI Report Server for scheduler refresh. When I try to do this I have the following error: Scheduled data refresh is unavailable for files not mapped to a network drive path.
I have nothing else installed like getaway, etc., because i don't know if I need to. Here is the error:
Thanks
11 Replies
You need to put your file in a network share (for your local server you can share one of your folders and consume the file from there), the shares typically have the format \\machineName\Folder
Thanks now it is ok, but I noticed 2 other issues:
Now the Data Source is ok(picture 1), but i still cannot set up the schedule (picture 2)
2. When I try to manually Refresh the data, nothnig happens. I made an attempt with changing some data in the excel, but the data in the report does not refresh when I click Refresh button. (picture 3)
If I open PowerBI Desktop, then refresh from there and Save to report server, the data is refreshed and it's ok, but with the botton from the report server it doesn't work.
BR
For the something went wrong check the logs ReportingServicesService*.log, (ensure you have your SQL Server Agent Service running).
In order to get new data you need a data refresh schedule, the refresh now button available in the report will refresh the visuals in the report if a data refresh schedule has been processed (in only refresh the visuals not the data)
Hello and thanks a lot . by making network adderss for my file, my problem has been resolved.
