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
pqian's avatar
pqian
Microsoft Employee
10 years ago

leonardmurphy hmmm...that's not what I'm expecting. I was hoping that maybe there is some DB with no model that could possibly explain the part that you can connect by specifying the right DB. 

 

In any case, to unblock your scenario, in the last update (December) we shipped a preview feature to lift the tabular model restriction on AS live connect. You can goto File->Options->Preview Features and enable this. Can you give this a try and see if you can now connect to the server (and maybe post a screenshot of the server under live connect to see if there are any clues)?

leonardmurphy's avatar
leonardmurphy
Skilled Sharer
10 years ago

I enabled the preview feature 'Explore live with SQL Server Analysis Services multidimensional models' as well as 'Use KPIs from Power Pivot or SSAS Tabular' - which are the two preview features that related to cubes.

 

It still shows that there are no tabular models if I type in the server name without specifiying a database.

 

If I do type in the database name, then this is what I see: