Forum Discussion

Marrafeiro's avatar
Marrafeiro
Helper I
6 years ago

Connection to a SQL Server

Hi all,   I need connect my local computer to a remote server with Windows, in this server i have my SQL Server. My questions is, how do i connect my Power Bi Desktop to that SQL Server? I already...
Need Help
Marrafeiro's avatar
Marrafeiro
Helper I
6 years ago

No, still can't connect.

I think i didn't explained well.

My Windows server need authentication to enter there, then in SQL Server need authenticate again.

camargos88's avatar
camargos88
Community Champion
6 years ago

Marrafeiro ,

 

It's look like you don't have access directly to your SQL server. If Power BI is installed on your machine, you can't connect like this.

Ask you IT Team if you can access the server from your machine, so you will be able to connect PBI to SQL Server.

 

YOU -> REMOTE DESKTOP -> SQL SERVER

 

YOU -> SQL SERVER

 

Unless you have directly access to the server, from the machine where PBI runs, you are not able to connect anything to your database server.

 

"My Windows server need authentication to enter there, then in SQL Server need authenticate again."

 

If you are the admin, check if the correct SQL Server/Firewall are open for it.

 

This is a network/security task.

  • Marrafeiro's avatar
    Marrafeiro
    Helper I
    6 years ago

    Ah ok, i understand now.

     

    Then another question. Is any possibility i can change a report data origim direct in power bi website?
    i upload the report to my account and then there change the origin?

     

    Thank you