Well the resolution involves a concept that you need to know about Analysis Service 2016. In Analysis Service 2016, we have introduced sqllitedb to store all the metadata of a project. In every project folder you will see a metdata.sqllitedb file inside it.
This file will have all the connection strings, data source details and the metadata of the project.
In order to open the file you have to download a tool called DB Browser for SQLLite(You can download it from this link: http://sqlitebrowser.org/ )
Once downloaded, open the tool and import the metdata.sqllitedb in it. Then click to the Browse Data tab and from the Table dropdown select DataSource.
In the table for the Data Source you will see a column named ConnectionString. (Refer the image below)
Click on the connection string value where the parameter is entered wrong.
On the right-hand side, you will see the value of the connection string in encrypted form.
All you need to do is to delete the connection string and then click Apply. (Refer the image below)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.