Forum Discussion

DavidJLitttle's avatar
DavidJLitttle
Frequent Visitor
7 years ago

Can connect to SQL Server but Databases are not visible

Afternoon, Im trying to connect to a local SQL Server Express Database. I can connect to the local server fine, but PowerBI doesnt list any databses available under the server ? I cant work out why
Need Help
DavidJLitttle's avatar
DavidJLitttle
Frequent Visitor
7 years ago

Hi, Im using SQL Server Express 2017 and SSMS v17 and im using Import rather than direct query. but neither work. The SQL login connects fine, but the Database list is blank

 

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    Hi DavidJLitttle ,

    First, we need to check if you have used the wrong server name, the server name "(LocalDb)\MSSQLLocalDB" is not a standard SQL Server instance, it is a localdb. 

    Then we need to check if these three databases are custom databases, the system database will not be displayed in the PowerBI list.

    After that, we need to check if the SQL Server login you are using have the permission to see these databases. Finally, we can use the SQL Server Profiler to check what's happened during this process.

    Best Regards,

    Teige

    • DavidJLitttle's avatar
      DavidJLitttle
      Frequent Visitor
      7 years ago

      Morning, What would be the correct ServerName ? PowerBI succesfully connects to the server instance and gets as far as where it should show me the list of databases, there just aren;t any. Also the login/user is windows authentication and the same credential i use to connect in SSMS and VB.Net and both of these applications have visibility of the databases. Also in SSMS the User mapping for the Windows credential is set to dbo for the database in question.