Forum Discussion

aistebuivyte's avatar
aistebuivyte
Frequent Visitor
8 years ago
Solved

sql

Hi,   I need to connect to sql database. Our customer provided user name, password, dbname, port and host. I try to write my server name as host:port. I get an error. Do I need to configure somethi...
  • Anonymous's avatar
    Anonymous
    8 years ago

    aistebuivyte,

    Could you please post the error message that you get? Are you able to connect to the SQL Server instance from SQL Server Management Studio(SSMS)? Make sure SSMS is installed in the same machine as Power BI Desktop, and configure remote access to your SQL instance following the guide in this blog.

    In addition, please review the following example to connect to SQL Server in Power BI Desktop, enter host, port as  Server.




    Regards,
    Lydia

aistebuivyte's avatar
aistebuivyte
Frequent Visitor
8 years ago

Thanks a lot for information provided. Unfortunately, I get an error below. That means I can't reach SQL server from SSMS. How could I solve this?