Forum Discussion

Douga's avatar
Douga
Frequent Visitor
9 years ago
Solved

Can't connect to SQL Server 2016 SSAS Tabular Model on local network server from Power BI Desktop

Hello,   I've got a SQL Server 2016 SSAS Tabular Model instance up and running on a customer's local network server. I VPN into the customers network to access their network and the server with the...
  • leonardmurphy's avatar
    leonardmurphy
    9 years ago

    Have you tried typing in the Database (cube) name? The field shows as optional, but I have one instance where, if I leave it blank, it won't find any cubes, but if I fill it in, it works just fine.

  • Douga's avatar
    Douga
    9 years ago

    Thank you leonardmurphy! That did the trick for me.

     

    So in summary here are the two things I needed to do.

     

    1. Run PowerBI Desktop from the command line under the context of the remote user.

    2. Enter the database (cube) name (even though it says it's optional)

     

    Thanks to all who helped with this!

     

    Douga

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Douga,

In Power BI Desktop, go to File -> Options and Settings -> Data Source Settings -> Global permissions-> find your SSAS data source->Clear permissions, then connect to SSAS using live option and check if it is successful.

Thanks,
Lydia Zhang

Douga's avatar
Douga
Frequent Visitor
9 years ago

Lydia,

 

Thanks for your help with this.

 

I’m still getting the “Server doesn’t have any models” message.

 

As you suggested previously, I am able to connect using “Runas”, but only using the “Import” selection. Using that selection, I did not need to enter a specific username/password so I’m pretty sure that with the “Runas” my credentials are being passed along.

 

I double checked that the windows user is an SSAS administrator.

 

I’ve tried different variations for “Server” - using the server name, server IP address, domain name\server name, domainname\IP address, and the servername:2383, etc. None seem to work.

 

Doug A.