Forum Discussion
joakre
4 years agoNew Member
Connect to SQL Server on a Remote Desktop
Hello! I am looking for some assistance on getting my Power BI Desktop to connect with the SQL server I currently utilize at my workplace. When I attempt to connect I get an error stating that ...
marcelsmaglhaes
4 years agoSuper User
Hi joakre !
Basically you just need pass the server address IP (or name). Its important to check if the database server accept connections trouhg the network (wich IP and wich port).
In Power BI Desktop, on the Home tab, select Get data > SQL Server.
In the SQL Server database dialog box, enter the Server and Database (optional) names, make sure the Data Connectivity mode is Import, and then select OK.
** If this post helps, please consider accept as solution to help other members find it more quickly.
Regards,
Marcel Magalhães