Error "Invalid username or password" Connecting to Microsoft Analysis Services

Published: 21 Aug 2014
Last Modified Date: 25 Apr 2016


When opening a workbook published to Tableau Server with a Microsoft Analysis Services connection, a prompt for login credentials might appear and no login credentials are accepted.

Or, in Tableau Desktop, the following error might occur when connecting to Microsoft Analysis Services:

Invalid username or password.

Additionally, the following error can be located in the Tableau Desktop logs:

MSG throw DataSourceException (type=BadPassword): Analysis Services database error 0x80004005: The peer prematurely closed the connection.


  • Tableau Server
  • Tableau Desktop
  • Microsoft Analysis Services (MSAS)


Configure firewall to allow the computer running Tableau Server and/or Tableau Desktop to connect to MSAS.


A networking or firewall issue is blocking the computer running Tableau Server or Tableau Desktop from connecting to Microsoft Analysis Services.
Did this article resolve the issue?