Forum Discussion

igordossantos's avatar
igordossantos
Helper I
10 years ago

Issues connecting to On-Prem Tabular Model

All,  We have the "Power BI Analysis Services" up and running to our tabular models in Dev and Prod environment.    For some reason, I have three users that are not able to see the databases on-pr...
Need Help
waltheed's avatar
waltheed
Impactful Individual
10 years ago

Hi,

 

SSAS Tabular only accepts Windows accounts, I mean accounts that exist in your local Active Directory (AD) domain.

Between logging to Power BI and accessing the data source, smart things happen.

 

Your local AD has to be synchronized with the Azure AD. So if you are trying this on your non-domain joined laptop, like I was, you can stop here...

 

The Power BI user is converted into an effective username which should be authorized as user on the SSAS Tabular Database. You can read that here.

Read from Usernames in Power BI and further

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-indepth/

 

Here is how to add User Principal Names, if you are allowed to

https://technet.microsoft.com/en-us/library/cc756018(v=ws.10).aspx

 

HTH,