OLAP, Analysis Services Questionssubmit your own question

I am trying to connect to remote Microsoft sqlServer 2016 Enterprise(ssas) using Visual Studio 2015 community. using (AdomdConnection conn = new AdomdConnection(@";Initial Catalog=CCAnalytics;Data Source=APPSWORLD\MSSQL;User ID=madhubabu;Password=sasa;Provider=MSOLAP.7;"))

I have several (more than 100) Excel reports (files) that use the same data connection file. The data connection file connects to SSAS 2012 Tabular Model.

Provider=MSOLAP;Data Source=http://serverName/;Initial Catalog=myDataBase;User Id=domain\user;Password=myPassword;Protection Level=connect;Transport Compression=None;Protocol Format=XML;