Forum Discussion

kaarel's avatar
kaarel
Icon for Resolver I rankResolver I
10 years ago

Azure VM and SSAS live connection map user name error

Hi! I'm trying to test live connection to SSAS multidimensional running on Azure VM with SQL 2016 Enterprise. It is not joined to any domain. I've mapped powerbi.com user names to local account vi...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

kaarel

 

Have you tested the rule in "Map User Name"? Make sure the returned name is exactly match the user name on your Azure VM. 

 

And "Map User Name" usually need few minutes to take effect, please wait for a while and test again.

 

Also make sure you update the latest gateway and check if there's any proxy setting in your environment. See a related thread: 

https://community.powerbi.com/t5/Service/Issue-with-Map-username-feature-in-SSAS-data-source/td-p/40617

 

Regards,

kaarel's avatar
kaarel
Icon for Resolver I rankResolver I
10 years ago

So it should work even if the Azure VM is not joined to a domain controller?

  • Morgan's avatar
    Morgan
    New Member
    10 years ago

    Hi Kareel

     

    I know what causes the problem but not how to fix it but thought this might help point others in the roght direction...

     

    This article seems to says it due to the SSAS host (in my case on-prem) being in a different domain to the account that I use to login in to Power Bi with.

     

    I've been playing about with the Gateway's "map user names" functionality to see if it lets me map the Power BI login to an on-prem account but this doesnlt seem to work (altough it did change the error retured by the data source to "there are currently no logon servers available to service the login request" which is probably becuase this is a demo environment and the on-prem SSAS instance isn't on a domain so maybe this would work if it was).

     

    Steve