Forum Discussion
Scheduled data refresh for local excel file
Microsoft EmployeeFor 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)
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.
- jtarquino
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
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
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