I am trying to access Access SQL server analysis 2019 via Excel > Data > From Other Sources > From Analysis Services.
but once enter the SQL server IP address and click on next the Excel gets frozen and nothing happens.
SQL version is 2019 and installed on a Windows Server 2019.
If I add the particular user to Windows 2019 server's, local admin group, it works without any issue, but due to security reasons, we do not want to give admin rights to normal users.
How to achieve this with minimum rights?