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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

perpor,

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

Regards,
Lydia

perpor's avatar
perpor
Helper V
8 years ago

I have the same error... 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    perpor,

    There are some proposals for you troubleshooting this issue.

    1. Enable TCP/IP in SQL Server Configuration Manager(SSCM).
    2. Configure a static port for your SQL instance in SSCM.

    3. Restart SQL Server Service in SSCM.
    4. Launch Power BI desktop with admin privileges, go to “File –> Options and Settings –> Options –> Data Load” to clear cache in Power BI Desktop, then connect to SQL Server by using "tcp:machinename,port" as Server, and write query to check if the connection is successful.


    If you still get error, please post the screenshot about the connection in Power BI Desktop.


    Regards,

  • perpor's avatar
    perpor
    Helper V
    8 years ago


    I have tried in the last few minutes and everything worked,

    I swear that I did nothing more than what I did before last weeks, there are also the screenshots ... bo ...

     

    true that now I have a new version of Power BI, but the version of Excel is always the same...

  • perpor's avatar
    perpor
    Helper V
    8 years ago

    I have always the error:

     

    "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 ONLY with this db and ONLY when I write a query, if I import the whole tables everything is ok

     

    PLEASE HELP HELP HELP !!!!!!!!!!!!!!!!!!!

  • a1b1c1's avatar
    a1b1c1
    Advocate I
    7 years ago

    Anonymous Thank you, works perfectly.

  • Akram's avatar
    Akram
    New Member
    6 years ago
    I have same problem, please what should I do?
  • pdacheva's avatar
    pdacheva
    Advocate II
    6 years ago

    Hi,

     

    I find a similar issue when trying to connect to Azure SQL DB. I can connect to the Server and load any table I want, but when trying to run a select statement I get an Authentication Error message (See attcahed). The select statement runs without a problem from SSMS, but in Power BI, no, even after using the proposed solution. I tried authenticating with the Admin of the SQL DB, and I got the same error. Again, this error is only when I try to run a select statement in the Advanced Options.

     

    Any suggestions are very welcome!