Hi @chamila kariyawasam ,
Thank you for your replying.
SQL permissions have been granted as you mentioned.
This permissions should be granted in SSAS as following:
1.created an test user in Computer Management and then added to Groups:
2.added a New Role into your SSAS and granted permissions to the user:
3.connect to SSAS from excel successfully.
it works without any issue if not excel get frozen and after about 20-30 minutes it opens.
If you could connect to the cube, it means there is no error for your connection. But the connection takes a long time, I suspect that your cube maybe have some script need to calculate so that you will take a long time to connect if you connect to SSAS from user side. And you could try to use SQL Server Profiler to get some details. For more information, please refer to this thread.
Best regards,
Carrin
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.