error when refresh the pivot table

You are missing provider for data connection.

Looks like you need SQL 2012 Native client from provider string.
Down load 64-bit or 32bit (whichever matches your environment) Microsoft SQL 2012 Native client and install it.
If it's already installed, you'd likely need to uninstall and re-install it.

https://www.microsoft.com/en-us/down....aspx?id=50402