KB3171516 - Update to add a security warning message when you schedule data refresh for PowerPivot workbooks

Applies To
SQL Server 2012 Developer SQL Server 2012 Enterprise SQL Server 2012 Enterprise Core SQL Server 2012 Standard SQL Server 2016 Developer - duplicate (do not use) SQL Server 2016 Enterprise - duplicate (do not use) SQL Server 2016 Enterprise Core - duplicate (do not use) SQL Server 2016 Standard - duplicate (do not use) SQL Server 2014 Developer - duplicate (do not use) SQL Server 2014 Enterprise - duplicate (do not use) SQL Server 2014 Enterprise Core - duplicate (do not use) SQL Server 2014 Standard - duplicate (do not use)

About the improvement

This update improves the user experience of Microsoft SQL Server 2012, 2014, or 2016 by adding a security warning message that appears in the following scenario:

  • You use PowerPivot for SharePoint on a SharePoint server, and the SQL Server version is SQL Server 2012, 2014, or 2016.
  • You upload a PowerPivot workbook to a SharePoint document library on the SharePoint server.
  • You schedule automatic refresh of the data in your workbook on the Manage PowerPivot Data Refresh page.

In this scenario, you receive a warning message that resembles the following:

Note

Text version:
Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source.
Do you want to refresh the workbook?

      

Resolution

This improvement was included in the following cumulative update of SQL Server:

Recommendation: Install the latest cumulative update for SQL Server

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. We recommend that you download and install the latest cumulative updates for SQL Server:

      

References

Learn about the terminology that Microsoft uses to describe software updates.