Forum Discussion

leonardmurphy's avatar
leonardmurphy
Skilled Sharer
10 years ago

Database Name Not Optional (SSAS Tabular Direct Connect)

Note: this question is similar to this (older) thread, but the functionality doesn't seem to be working exactly as designed, preventing me from doing what I need: http://community.powerbi.com/t5/Desk...
Need Help
leonardmurphy's avatar
leonardmurphy
Skilled Sharer
10 years ago

It's good to know it's unique to me. It's likely not a Power BI Desktop issue then...probably something with my server.

 

I'm using PBI Desktop 2.30.4246.281 64-bit (December, 2015)

 

The name is fully qualified. The cube is definitely tabular :)

 

BUT...I tried connecting to a different server and that worked without me specifying the database name. So that also points to it being a difference between the servers. (The one that works has a database engine, SSIS and SSAS tabular - the one that doesn't work has SSRS and SSAS tabular).

 

That makes me feel a lot better.

pqian's avatar
pqian
Microsoft Employee
10 years ago

leonardmurphy, Something is definitely unique about your server. Would it be possible to give me access to that server (assuming it's on the cloud)?

  • leonardmurphy's avatar
    leonardmurphy
    Skilled Sharer
    10 years ago

    It's an on-prem server.

     

    I'll have to run remote access by some folks. I'll get back to you (probably next week).

     

    I've tried a few different things (syncing a 2nd cube to the server, deploying a cube directly to the server) to see if that triggers recognition of tabular models. No luck. The message about there being no tabular models is instantaneous too...it's not trying to connect and timing out or anything like that. 

     

    The impact to me is small right now (I can develop my reports against the server in question from the get-go).

     

    Thanks for your help narrowing this down so far pqian and Anonymous