Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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 th...
services
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

 

Here is the conncetion to the SQL server:

 

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!

jtarquino's avatar
jtarquino
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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