I'm trying to publish an Excel workbook which loads data from SQL Server. The result is: no data loaded in the workbook and no error logged on Sharepoint logs.
Notice that if I try to refresh the workbook in Office Excel all works fine!
I try to set up Windows Authentication, None (to use unattended account) and with .odc file but with no result!
The procedure I follow is:
1) create a new Excel file and create new data connection to the database (SQL Server 2008)
2) upload the file in the trusted file location
3) open the file in a web part and click on the "refresh all" button
I used the same unattended account which I setup for this purpose with BCS and it works fine!
I also try to set with PowerShell the Application ID created ("ES"):
"set-spexcelserviceapplication -identity 6d871d92-19dd-4421-b33b-0012f9a5ea18 -unattendedaccountapplicationid ES"
with no result.
I noticed that the identity of the Excel Service application shown in the Central Administration isn't in the IIS Application Pool list: could it be the problem?
I also tried to delete / re-create the application but the two IDs remains disequal!
Have someone of you already worked with Excel Services and could give me any help?
Thanx in advance,
View Complete Post