cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ultrashock Regular Visitor
Regular Visitor

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:

Data sources - Markets 09.112017-TEST_EXCEL - Power BI Report Server - Google Chrome.jpg

Thanks

10 REPLIES 10
Highlighted
Power BI Team jtarquino
Power BI Team

Re: Scheduled data refresh for local excel file

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

ultrashock Regular Visitor
Regular Visitor

Re: Scheduled data refresh for local excel file

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)1.jpg2.jpg

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.

 

3.jpg

 

BR 

 

Power BI Team jtarquino
Power BI Team

Re: Scheduled data refresh for local excel file

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)

ultrashock Regular Visitor
Regular Visitor

Re: Scheduled data refresh for local excel file

Can you tell us a little bit more about: ReportingServicesService*.log and how to be sure tha SQL Server Agent Service is running? Why SQL Server Agent Service is needed if I refresh from Excel file? 

Today I have updated On-premises data gateway (personal mode) to the newest version.

 

 

Power BI Team jtarquino
Power BI Team

Re: Scheduled data refresh for local excel file

The process in charge of create schedules is ReportingServicesService so any error creating schedules will show up in those logs.

SQL Agent is needed because PBIRS use it as the scheduler agent (it knows how to do an action at a certain date and time) basically the SQL Agent notifies PBIRS that have to start to refresh a report.

 

PBIRS doesn't use the gateway, that is only for PowerBI.com

ultrashock Regular Visitor
Regular Visitor

Re: Scheduled data refresh for local excel file

MS SQL is installed on other server. What settings should I do in order which is the address of the server and what else is needed as settings in oder to make it works?

I'm not sure what PBIRS exactly is, maybe you mean this Reporting Services Configuration Manager:

111.jpg

Thanks!

Power BI Team jtarquino
Power BI Team

Re: Scheduled data refresh for local excel file

Apologies for the abbreviation PBIRS is Power BI Report Server.

 

The new screenshot you show is SQL Server Reporting Services, I'll assume is a different server from the one you start the question about excel refresh.

 

The best way to get to the root of your problem is checking the logs in your Power BI Report Server, you will find them in C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\ReportingServicesService*.log

 

Regards

ultrashock Regular Visitor
Regular Visitor

Re: Scheduled data refresh for local excel file

Detailed information:

Server 1 : ERP and MS SQL, nothing else connected with PowerBI;

Server 2: Power BI Report Server and On-premises data gateway (personal mode), for which you said that is unnecessary and I will uninstall it.

 

On Server 2, where is the Power BI Report Server I have made a connection to the SQL server.

Here are all the settings for Power BI Report Server:

1. Account: Network Service

1.jpg

 

2.jpg3.jpg

Here is the conncetion to the SQL server:

5.jpg6.jpg7.jpg4.jpg

 

Power BI is working ok from any computer in the local network. Only the data refreshing is not working. Am I missing something or maybe doing something wrong.

That's all! Thanks in advance!

Power BI Team jtarquino
Power BI Team

Re: Scheduled data refresh for local excel file

The configuration seems correct, I would check the logs mentioned before to see the exact error that the server is having when ytou try to create a data refresh schedule, also ensure the SQL Agent is started and running in what your sceenshot shows as Server1

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 345 members 3,868 guests
Please welcome our newest community members: