A BACPAC is a .bacpac file that contains a database schema and data.

import bacpac

import the exported BACPAC from an SQL Azure (v12) database into a local SQL Server 2012 instance

Error

Internal Error. The database platform service with type Microsoft.Data.Tools.Schema.Sql.SqlAzureV12DatabaseSchemaProvider is not valid.

You must make sure the service is loaded, or you must provide the full type name of a valid database platform service. (Microsoft.Data.Tools.Schema.Sql)

Solution

The issue here is the version of the Client Tools.  In my case, Management Studio. 

If I use the SQL 2014 (v12) version of Management Studio to import that BACPAC to my SQL 2012 server, it works successfully.

Remark

SSMS for SQL Server 2014 is the only version of SSMS with full support of the new Azure SQL DB v12 features, notably Import/Export against this target.

This is because v12 has (almost) feature parity with SQL Server 2014 and older versions of the tooling do not have support for this. Note that SSMS 2014 is fully backwards compatible with SQL Server 2005 and up.

Install the following and it will work!

1) Have you installed Cumulative Update 5 for SQL Server Management Studio 2014. http://support2.microsoft.com/kb/3011055

2) Microsoft SQL Server Data-Tier Application Framework (February 2015) (you must install BOTH the x64 and x86 versions).

http://www.microsoft.com/en-us/download/details.aspx?id=45886

https://www.microsoft.com/en-us/download/details.aspx?id=51186