Excel Authentication Error

Excel Authentication Error

Issue

When you open Excel a TABS connected Excel report and attempt to sign in using your credentials, an authentication error occurs. 

Examples of errors:
  1. AADSTS50011: The reply URL specified in the request does not match the reply URLs configured for the application.
  2. The database driver does not include the necessary capabilities and cannot be used with Excel. 

Solution
TABS uses Azure Analysis Services to host our data models and enable real-time analytics. If you would like to interact with our live data using Connected Excel, you must have the correct Microsoft Client Library installed on your computer. Installing this library enables Excel to connect to our Azure Analysis Services model(s). It is a standard Excel library and is not customized for TABS in any way.

Download the Microsoft Client Libraries

Download and install the Microsoft Client Libraries:
Microsoft keeps this page updated so that you can always find the most recent version. Install all of the libraries as shown below including the 64-bit (amdx64) and 32-bit (x86) versions. 



    • Related Articles

    • Issues Logging into the TABS Web Portal or Excel

      Issue: When you try to log into the portal or Excel, you get an error saying the selected account does not exist. Solution: NOTE: If your account isn't connected to Windows and you have to enter your email address at the start, these directions won't ...

    • Introduction to Connected Excel

      Please check out this video overview of the Connected Excel experience.  

    • Connected Excel Requirements

      Requirements TABS uses Azure Analysis Services to host our data models and enable real-time analytics. If you would like to interact with our live data using Connected Excel, you must have the correct Microsoft Client Library installed on your ...

    • Unblock Excel Files Containing Macros

      Note: Some users are experiencing blocked Macros in Excel. If you receive that message, please follow the instructions below or via this link: Unblock a File with Macros In most cases you can unblock macros by modifying the properties of the file as ...

    • Refresh a Locally Saved Connected Excel File

      To refresh a locally saved Connected Excel file to the latest refresh date, open the file and go to the Data tab in the ribbon. Click Refresh All. The document will refresh to the most recent refresh date.