Forum Discussion

itays's avatar
itays
Regular Visitor
3 years ago
Solved

Connecting to a remote SQL Server using the DirectQuery method

Hi, I have a SQL Server database running on some server on the network. I have another machine on the same network which runs the gateway to that SQL Server database and it functions correctly. I'm...
Tutorial Requests
  • ToddChitt's avatar
    ToddChitt
    3 years ago

    Your original post indicated that when designing a Power BI model that was to connect to SQL Server, you got an error stating that it could not find that SQL server on the network. You are desiggning from you LOCAL MACHINE correct? Does that LOCAL MACHINE have the ability to connect to the SQL Server?

serives4's avatar
serives4
New Member
3 years ago

Connecting to a remote SQL Server using the DirectQuery method in Power BI involves establishing a live connection between your Power BI report and the SQL Server database. This method allows you to retrieve and visualize data directly from the SQL Server in real time. Here's how you can do it:

1. Prepare Your SQL Server:

  • Ensure that your remote SQL Server is properly configured and accessible from the network where your Power BI application resides.
  • Make sure you have the necessary credentials (username and password) to connect to the SQL Server database.
  • chiropractor rome, ga