Forum Discussion

Humanoidhuman's avatar
Humanoidhuman
Frequent Visitor
2 years ago
Solved

Connect Linked SQL Server to Power BI Desktop

Background and Problem: I am trying to create a Power BI report using data pulled from MSSQL server to which I have access. I am able to successfully connect to the primary SQL server using the regu...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    In your connection definition try running a SQL query against the linked server.

lbendlin's avatar
lbendlin
Super User
2 years ago

In your connection definition try running a SQL query against the linked server.

  • Humanoidhuman's avatar
    Humanoidhuman
    Frequent Visitor
    2 years ago

    I tried running the a SQL script under advanced options while establishing connection to the server (picture below), but it asks for a database. For this I tried entering the linked server name as well but it doesn't establish connection saying authentication failed. I double checked my credentials and permissions all the server they seem to be all there. 


    I am also attaching the script I used below for reference

    SELECT * FROM linkedserver.Runtime.dbo.History 
WHERE TagName = 'SysTimeSec' 
AND DateTime >= '2023-09-12 12:59:00' 
AND DateTime <= '2024-01-12 13:00:00'


    Please let me know what I am doing wrong. TIA!

     

    • lbendlin's avatar
      lbendlin
      Super User
      2 years ago

      Use the initial server and database for the connection. The database is NOT optional, that dialog title is faulty.

      Then run the query as you listed it.

      • Humanoidhuman's avatar
        Humanoidhuman
        Frequent Visitor
        2 years ago

        Thank you for that. However, as you can see below, the linked servers do not fall under the any database. For this purpose I am unable to discern what to enter as a database when linking to the SQL server