Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi everyone,
in our setup we have two VMs running on Azure, a Windows 10 Client and a Windows Server 2019 Datacenter, which are both ONLY Azure Domain Joined with our Azure Active Directory. The goal is to connect to a SSAS Instance on our server using our Azure AD Credentials. The problem is when using our local windows admin credentials we can connect to our SSAS instance, but when using our Azure AD Crendentials the connections cannot be established.
Error Message:
The used Azure AD user is stored as a privileged user in the SSAS database.
Does anyone have any experience with this setup/problem and can help?
Sincerely,
Minh
Solved! Go to Solution.
@Anonymous Yes, i found a solution for our case. The fault was in our setup. With the command
dsregcmd /status
you can look at the state in which your device is.
Our VM was AzureAdJoined and our server with the SSAS instance was DomainJoined. Confusingly, you could still log in with the azure crendentials on both devices. Now both devices in our setup are DomainJoined with our Azure AD Domain, so the credentials are correctly transmitted and we can log on to our SSAS instance with our Azure AD Credentials.
So our conclusion is that both devices have to be either AzureAdJoined or DomainJoined.
@Anonymous Yes, i found a solution for our case. The fault was in our setup. With the command
dsregcmd /status
you can look at the state in which your device is.
Our VM was AzureAdJoined and our server with the SSAS instance was DomainJoined. Confusingly, you could still log in with the azure crendentials on both devices. Now both devices in our setup are DomainJoined with our Azure AD Domain, so the credentials are correctly transmitted and we can log on to our SSAS instance with our Azure AD Credentials.
So our conclusion is that both devices have to be either AzureAdJoined or DomainJoined.
Hi @minh
According to your image, it seems that your server name is incorrect, please make sure your server name is correct. You could refer to connecting-power-bi-to-an-azure-analysis-services-server for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@dax thanks for the answer, but i'm pretty sure the name is correct. The connection is working if i login with my local windows credentials on the VM. The problem only arises when I log on to the VM with the Azure AD user and want to establish a connection.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
63 | |
56 | |
27 | |
17 | |
13 |