FIX: "allow mixed content" popup when you use PowerView that contains map data in SSRS on SharePoint website

Applies to: SQL Server 2014 Business IntelligenceSQL Server 2014 Business Intelligence

Symptoms


Consider the following scenario:
  • You have a Microsoft SharePoint website that is hosted on HTTPS endpoint.
  • You use PowerView in Microsoft SQL Server 2012 Reporting Service (SSRS 2012) or SQL Server 2014 Reporting Service (SSRS 2014) on the SharePoint website.
  • You have a PowerView worksheet that contains map data.
In this scenario, the map is displayed, and Internet Explorer throws up the "allow mixed content" popup upon the map.

Cause


The issue occurs because the Bing Logo URL returns HTTP instead of HTTPS, even though the website is hosted on HTTPS endpoint.
Internet Explorer has a security policy that, if you are on an HTTPS website, and the website tries to make an HTTP call, then you receive the "allow mixed content" popup.

Resolution


The issue was first fixed in the following cumulative update of SQL Server.

Cumulative Update 4 for SQL Server 2014

Cumulative Update 2 for SQL Server 2012 SP2

Cumulative Update 11 for SQL Server 2012 SP1

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.