Forum Discussion

itays's avatar
itays
Regular Visitor
2 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 trying to create a live report, which uses the DirectQuery connectivity method, and I cant seem to connect to my data source.

When I use the import method - I can choose my gateway and connect to the source, but using DirectQuery I can't provide any credentials other than server address.

Is there even a way to connect to a remote SQL Server using DirectQuery?

Providing server nameFailing to connect (Probably since no credentials have been provided)

Tutorial Requests
  • ToddChitt's avatar
    ToddChitt
    2 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?

11 Replies

Replies have been turned off for this discussion
    • itays's avatar
      itays
      Regular Visitor
      2 years ago

      Thanks for your reply. I have tried providing the database name, still no connection was made.

      The database is secured with a username and password and it seems impossible to connect to it without providing any credentials.

      • ToddChitt's avatar
        ToddChitt
        Super User
        2 years ago

        >>The database is secured with a username and password and it seems impossible to connect to it without providing any credentials.<<

        Is this a surprise to you? What happens when you supply theese? Do you even have them? If not, that's not Power BI's fault.

         

        Me to my mechanic: My car won't start!

        My Mechanic: OK, let me have the keys and I will try it.

        Me: I don't have the keys.

        🙂

  • serives4's avatar
    serives4
    New Member
    2 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