Change the Connection of Excel Dashboard

Issue #

  • When selecting the values in the report it show the error below?

Environment #

  • OS: Unix
  • SQL Server

Resolution #

  1. Open the Open iT Analysis Server webpage and go to ‘Administration’ tab.
  2. Copy the values of ‘data source=’ and ‘initial catalog=’ from the connection string of Olap Server Connection.
  3. Open the excel file and go to ‘Data’ tab then connections.
  4. Click on the ‘Properties’ of the connection name then go to ‘Definition’ tab.
  5. Change the values of ‘data source=’ and ‘initial catalog=’ to the connection you have copied from your connection string of Olap Server Connection.
  6. Click ‘Ok’ to save connection then data will automatically refresh.
X