Forum Discussion

Copper Contributor

Jun 18, 2025

Solved

Analysis Server Roles from Entra workstation

We have Analysis Server solution, maintained and deployed from Visual Studio, where the roles defined use AD groups. This worked perfectly as long as long as the machine used was on the same domain a...

bandaruajeyudu
Jul 01, 2025
Hi StigJ ,
I ran into this before, it's because Entra-only machines can not browse AD groups in SSAS.
Quick fix: Just manually type the AD group (like DOMAIN\GroupName) when adding to the role, it works even if you can not browse.
Or, if you need the GUI to browse groups, best to use a domain joined or hybrid joined machine. Hope that helps!

bandaruajeyudu

Brass Contributor

Jul 01, 2025

Hi StigJ ,

I ran into this before, it's because Entra-only machines can not browse AD groups in SSAS.

Quick fix: Just manually type the AD group (like DOMAIN\GroupName) when adding to the role, it works even if you can not browse.

Or, if you need the GUI to browse groups, best to use a domain joined or hybrid joined machine. Hope that helps!

StigJ
Copper Contributor
Jul 02, 2025
Hi,
many thanks for the reply. Good to get confirmed that it is not just us that have this issue. We did indeed end up by creating a hybrid joined machine to work around the issue. Not ideal, but....
Strange thing is that the quick fix do not work for us. And in Visual Studio Data Tools it will not even open the dialog window when clicking Add in Membership. But I guess that is another issue. We do have the workaround now.