Error "Database error 0x80004005 ... Exception has been thrown by the target of an invocation." connecting to Microsoft Analysis Services hosted on Azure

Published: 30 Nov 2018
Last Modified Date: 17 May 2019


When trying to connect to Microsoft Analysis Services hosted on Azure (also known as AAS, Azure Analysis Services), the following error may occur:
Database error 0x80004005: COM error: COM error: mscorlib; Exception has been thrown by the target of an invocation.. Unable to connect to the server. Check that the server is running and that you have access privileges to the requested database.


Database error 0x80004005: Errors in the OLE DB provider. Unable to obtain authentication token using the credentials provided.  


  • Tableau Desktop 
  • Microsoft Analysis Services hosted on Azure (also known as Azure Analysis Services Server)


Step 1: Verify Client Libraries and install if needed.

  1. From the AAS dashboard, select Settings > Connection Strings.
  2. Hover over the "i" icon to the right of "Provider" and click on the "Analysis Services Data Providers" link.
    .Step 1 Illustration
  3. Follow the steps in Client libraries for connecting to Azure Analysis Services  to install MSOLAP(amd64), MSOLAP(x86), AMO, ADOMD libraries. 
  4. Verify that msolap.dll is version and Microsift.AnalysisServices.DLL and Microsoft.AnalysisServices.AdomdClient.dll are version 

    Step 2 Illustration

Step 2: Set up the connection in Tableau Desktop.

  1. Select Connect > To a Server > More > Microsoft Analysis Services. 
  2. In the connection dialog, do the following:
    • In Server, paste the Azure Analysis Services server name.
    • Select "Use a specific username and password".
    • For Username, enter the email address you use to sign in to the Azure portal.
    • For password, input a single space. A pop up window will appear to authenticate you through Azure Multi-Factor Authentication. Please note that if your Active Directory tenant administrator has configured Multi-Factor Authentication or if your account is a Microsoft Account, please specify empty values for 'User Name' and 'Password' fields, and then retry. You should then be prompted to enter your credentials.

    User-added image


The MSOLAP drivers are attempting to authenticate immediately with a username/password combination. Since the Azure proxy requires authentication before you can communicate with the Analysis Services server, the connection attempt is failing.
Did this article resolve the issue?