Forum Discussion

perpor's avatar
perpor
Helper V
8 years ago

Unable to connect Power BI to SQL server db on the same computer

I works a lot with Power Bi and Sql server, from many months, with the db on a server remote, no problems. I have created a Sql server db on my computer, where Power BI is installed, and I can conne...
Need Help
perpor's avatar
perpor
Helper V
8 years ago

But I can't write any query, there is always the error writing a query...

Anonymous's avatar
Anonymous
Not applicable
8 years ago

perpor,

What error message do you get when you write a query in Power BI Desktop? In your scenario, please make sure the following things.

1. Ensure that you use the latest version of Power BI Desktop(2.50.4859.502).
2. Ensure that the query you write runs without issues in SQL Server Management Studio.
3. Specify machine name\instance name or IP\instance name as Server when connecting to SQL Server in Power BI Desktop.


Regards,
Lydia

  • perpor's avatar
    perpor
    Helper V
    8 years ago

    Error is always:

     

    "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
    The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow
    remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

     

    and I have verified many times the points 1., 2., 3., always ok

     

     

    • perpor's avatar
      perpor
      Helper V
      8 years ago

      I have tried also with a sql server connection, not onlt with windows connection, and I have create a user on db with permissions,

      but the problem is always the same

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        perpor,

        How about you connect to SQL Server in Excel and write query?

        Regards,
        Lydia