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
Anonymous's avatar
Anonymous
Not applicable
10 years ago

igordossantos I would first suggest you take a look at the AS in depth documentation under "Where things can go wrong" to check some of the potential issues off your list.

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-analysis-services-connector-indepth/

in that post you'll also find a link to the troubleshooting page which has additional areas you should verify are set up correctly.

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-troubleshoot-analysis-service-connector/

 

Let me know if you've gone thru all this already and still have an issue, otherwise there is a wealth of information to verify in these to posts that will most likely lead to a resolution.

  • igordossantos's avatar
    igordossantos
    Helper I
    10 years ago

    Eno, 

     

    I'm going through the links you sent right now. 

     

    Below are the informational and error messages that both of my users are seeing when they try to connect to the data on-prem:

     

    Informational:

    Creating new MSOLAP connection to AS server. Activity ID: 05c5f73d-1d5b-45e3-969f-3d2ac4302861
    Activity ID: 05c5f73d-1d5b-45e3-969f-3d2ac4302861

     

    Informational:

    Do impersonation for user domain\bi-asconnector-dev. Activity ID: 05c5f73d-1d5b-45e3-969f-3d2ac4302861
    Activity ID: 05c5f73d-1d5b-45e3-969f-3d2ac4302861

     

    Error:

    Open MSOLAP connection failed. The connection string is Provider=MSOLAP.5;Data Source=server|dev;transport compression=None;protocol format=XML;[email protected];sspropinitappname="PowerBI - Model Creation";timeout=180. Activity ID: 05c5f73d-1d5b-45e3-969f-3d2ac4302861
    Activity ID: 05c5f73d-1d5b-45e3-969f-3d2ac4302861

     

    Do they need any specific rights at the AD level in order to impersonate a the login? Because remember that I and another domain admin user can get to the on-prem data.