Dear MS Support,

i'm newbie in sharepoint, especially in sharepoint 2013. i'm interest in MS BI and collaboration with sp2013.

but  after i install the sp2013 and add file excel using excel 2013, and has scatter chart inside the file, the file doesnt want to shown up. first, i read the error is about the reporting service that need to be check and configure, but after i follow the step that i have got on internet, the error wont go away, and still appear.

here is the installation taht i've made, please check if i had miss or set the configuration wrong.

http://www.4shared.com/office/FInvHzEC/Instalasi__Autosaved__docx.html

and here the error and the capture when i try to re config the reporting service.

and 

so please help me to solved this issue.

thanks in advance

Regards,

Bambang

Hi,

You need to choose to either use Excel services or Excel Web Apps they both have advantages. To suppress opening the file in Excel webApps use the following PowerShell cmdlet, this will resolve the error

• New-SPWOPISuppressionSetting Extension XLSX -Action view
• New-SPWOPISuppressionSetting Extension XLS -Action view

This will allow Excel services to be used to view the files or your installed Desktop Client used to edit them..

Excel Web App and Excel Services in SharePoint have a lot in common, but they are not the same. Excel Services is available only in the Enterprise edition of SharePoint Server 2013. Excel Web App is available in SharePoint Server 2013 and SharePoint Foundation 2013. Both applications enable you to view workbooks in a browser window, and both enable you to interact with and explore data.

But there are certain differences between Excel Web App and Excel Services in SharePoint. For example, Excel Services supports external data connections, data models, and the ability to interact with items that use data models (such as PivotChart reports, PivotTable reports and timeline controls). Excel Services provides more business intelligence functionality than Excel Web App, but Excel Services does not enable users to create or edit workbooks in a browser window.

Reference:

For details about the differences between the Excel Web App and Excel Services, see Overview of Excel Services in SharePoint Server 2013 and Comparing Excel Services in SharePoint to Excel Web App.

-Ivan

 

 

 

         

 

 

Hi Ivan,

thanks for the quick response.

i had installed sp2013 evaluation license, does it enterprise edition ?

and i think the main problem is, i forgot to mention, that i can open the excel file with other charts (line,donuts,pie,etc) but not the chart with animation affect like scatter.

the following error describe that i have to confnig the reporting service,which it i already did and i got the  services started, but its not solving the issue. can you explain to me why ?

but i'll try your solution first.

Best Regards,

Bambang

Dear All,

i already solve it using this guidence.

http://www.4shared.com/file/-mSfcNWVba/PowerBI_environment_setup.html

thanks

• Marked as answer by Bambang Priantoro 2 hours 52 minutes ago