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

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