今天在使用excel 2013,创建powerview过程中,然后发布到sharepoint server 2013。然后通过excel services浏览xlsx文件,遇到一个问题,无法显示powerview。
查了很多资料,发现是服务器场,缺少了两个值得。
InteractiveReportServiceUrl – This is the URL Pointer for Excel Services to redirect to the Power View page and render the Power View report. If this isn’t present, then Excel doesn’t know what to do with the Power View Report that is within the Excel Workbook.
InteractiveReportApiUrl – This is a helper Javascript file for use with Power View.
最后通过以下方法,得到解决。
打开sharepoint 2013 powershell运行程序,用管理员方式运行。
$farm = Get-SPFarm
$farm.Properties
$propName = "InteractiveReportServiceUrl"
$propValue = "/_layouts/15/ReportServer/AdHocReportDesigner.aspx?ViewMode=Presentation&DeferredInitialization=true&Fit=true&PreviewBar=false&BackgroundColor=White&AllowSectionNavigation=false&EnableKeepAlive=true&AllowEditViewMode=false&AllowFullScreenViewMode=false"
$farm.Properties.Add($propName, $propValue);
$propName = "InteractiveReportApiUrl"
$propValue = "/_layouts/15/ReportServer/InteractiveReportAPI.js"
$farm.Properties.Add($propName, $propValue);
$farm.Update($FALSE)
执行完以上命令之后,重新启动iisreset,然后再打开xlsx文件,发现sheet中的powerview,已经能浏览了。