I am not able to refresh the data in Excel when to see the excel report in a browser. When I press Refresh All options the page gets refresh but no update in data is reflected.
Actually, I have two versions of SQL Server installed on my machine
Sql Server 2008 R2 (Standard Edition) for SSRS
SQL Server 2012 R2 (Enterprise Edition) for PowerPivot and PowerView
I think the issue is whenever excel services try to refresh the data they search for Old assemblies of Analysis service but it was overwritten by New assemblies while installing SQL server 2012 R2.
I have created whole Excel service application but issue is still there.
Also, I am not able to publish the workbook in SharePoint library with authenticated users credential, the workbook only publishes with Admin's credential. Is there any group where I need to add authenticated user account.
Please tell me how to come out of these issues.
Thanks in advance