Forum Discussion

rammy's avatar
rammy
Helper I
4 years ago

Using power bi How to connect company SQL server from my pc

Hi Power bi community 

i am new to power bi as of now my manager gives me a task how u will access my server in remotely by doing some modifications in sql.

At that time i am telling i want search and let u know .But as of now i didnt find any thing related to my query.

The problem i want to connect company sql server from my pc using power bi to fetch data and doing visualizations.

but  im trying some modifications like allowing remote control and udp/tcp port changing ,firewall like all these im tried but i did not fetch the data from SQL to power bi . so if any one knows what type of modifications do i need to change in sql server to give me the access from remotely please let me know   ASAP...

 

Thanks in Advance

Need Help

10 Replies

  • HashamNiaz's avatar
    HashamNiaz
    Solution Sage
    4 years ago

    Hi rammy !

     

    First of all you need to fix SQL Server connectivity issue from your local machine / laptop. Meaning you should be able to access SQL Server from your local machine using SSMS (SQL Server Management Studio). 

    Your IT needs to open SQL Server for remote connections. Once you are able to access SQL Server from your local machine, you can simply connect with SQL Server using same credentials from Power BI Desktop.

     

    Your IT might have a VPN setup whih allows you to access SQL Server through secure tunnel.

     

    Regards,

    Hasham

  • rammy's avatar
    rammy
    Helper I
    4 years ago

    Hi HashamNiaz 

    In our company no IT team is here ,actually we are the support team in our company . i joining previous month only in our team no one knows clearly ,we just tried above mentioning points only.if i do remote access ,port,firewall rule in my company server ,does it require to made some changes in my local pc access also like what ever i did in company server if do same in my pc also is it enough to access the server .help me in this please 

    Thanks in advance 

    • Icey's avatar
      Icey
      Community Support
      4 years ago

      Hi rammy ,

       

      Here is an official document describes how to enable the protocols, configure the ports, and configure the Windows Firewall for connecting to SQL Server from other computers. Please check if it could help you.

       

      Reference:

      Lesson 1: Connecting to the Database Engine - SQL Server | Microsoft Docs

      Lesson 2: Connecting from Another Computer - SQL Server | Microsoft Docs

       

       

      Best Regards,

      Icey

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • rammy's avatar
        rammy
        Helper I
        4 years ago

        Hi Icey 

        Thanks for your information . i want to know that this connection has been established in  same network or differnt network  .if it is different network how can i configure from my home pc to company pc which has been placed in Australia .If you know the things please help me to resolve this 

         

        Thanks in advance