Perhaps you have faced this error: “There are currently no logon servers available to service the logon request” while connecting to SSAS (Analysis Services) for the first time in Power BI via Gateway. In this post I will show you two possible solutions:

  1. Active Directory Installation

    For Windows 10 or 8, maybe you will have to install Active Directory Users and Computers as well as other Active Directory applications. These tools are not installed by default, but here is how to active them. 1) Download and install one of the following depending on your version of Windows: Remote Server Administrator Tools For Windows 10, 8 or 8.1)
    2) Go to “Control Panel“ >  “Programs“ > “Programs and Features” > select “Turn Windows features on or off“ > Expand the “Remote Server Administration Tools” > “Role Administration Tools“ > “AD DS and AD LDS Tools“ > “AD DS Tools” must be checked, then select “OK“.
    3) You should have an option for “Administrative Tools” on the Start menu. From there, select any of the Active Directory tools.

    Then, you will be able to have a “logon server” and solve your error, but don’t forget to grant access for the DOMAIN\User in your SSAS role.

  2. Power BI account X AD Account

    Try to add a new user into your Active directory, with same name that you registered in the Power BI account. Then, change UPN of the user in AD (Active directory) to that of Power BI User. For example, in AD you will create a USER@local.host, you will have to change the UPN to USER.domain.com, as this is your login name in Power BI. After that you will be able to see data in your datasets and populate it from SSAS cubes.

Last tip, SQL Server Profiler is your best friend to troubleshoot SQL Server AND Analysis Services, see who is connecting, what is the client, NT User, Start time, cube, mdx, xmla, etc.

sql profiler for analysis services
sql profiler for analysis services

Leave a Comment

Your email address will not be published. Required fields are marked *