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
jtarquino's avatar
jtarquino
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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:

Thanks!

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

    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

    • 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