Hi All,

When we deploy any PowerPivot Data Model to SharePoint 2013, we get the following options-

1. Create New PowerPivot Report

2. Create New PowerView Report

3. Schedule Data Refresh

These options work fine as long as we deploy a normal Excel Data Model file like .xlsx . 

However, When I deploy Data Model with some VBA code (Macros, VB functions) contained within it i.e. Macro Enabled file - .xlsm, the above options didn't work. I got following error while creating a New PowerView report as 

It says that your Excel has unsupported features like Macro function.

Can't we create a new PowerPivot/PowerView report with Macro Enabled Data Model? Is this not supported in SharePoint 2013?

Thanks in advance.

Regards,

Rameshwar

• Edited by Rameshwar Pawale Monday, August 31, 2015 1:22 PM

Hi Rameshwar,

It will take some times for Microsoft to investigate the suggestion and check if it would be necessary to enable feature to the next version of SQL Server. If the feature is enabled, Microsoft will announce is on MDSN document. Thank you for your understanding.

Regards,