When you create a pivot table from an OLAP cube and the OLAP server is defined to a port number other than the default, the connection string might display the incorrect port. The connection string might display the default port of 5451 rather than the port defined to the OLAP server. Even though the port displayed is incorrect, the data can still be refreshed without errors.

There is no workaround for this issue. 

Operating System and Release Information