Forum Discussion
Database Name Not Optional (SSAS Tabular Direct Connect)
If I select import data, I am not required to enter a database name. Instead, I am prompted for my credentials. I select windows credentials, and then the Navigator appears. There is only one database on the server in question, but in the Navigator to import data it shows several drill downs under the database.
I can then choose my tables and import.
The servers are all on the same domain, but the enterprise gateway is installed on a different server than either SSAS instance.
SSAS is SQL 2014 Enterprise SP1: 12.0.4100.1
Note: Edited to include image rather than description and add server version. (I wasn't signed in so the upload image option wasn't there when I first replied)
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)?
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:
leonardmurphy I can't seem to replicate the issue your having. (current desktop Version: 2.30.4246.181 64-bit (December 2015))
I see all my tabular models when inputting the instance name... Couple additional thoughts:
Have you tried to fully qualify the name?
Have you checked to make sure the SSAS instance is installed correctly? Set up as Tabular not Multidimensional? Or is everything set up right and you've already determined the problem exists in PBI?
