Forum Discussion
leonardmurphy
10 years agoSkilled Sharer
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...
leonardmurphy
10 years agoSkilled Sharer
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)