Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Cannot connect Power BI with SQL server

Hi, I found issues with connecting Micsrosft SQL Server with Power BI. I do not have any experience in such connections, so I am blindly doing different steps but I simply don't uderstand what I am d...
help needed
divyed's avatar
divyed
Super User
1 year ago

Hello Anonymous ,

Follow below steps :

 

1. Open Power BI => Get Data => SQL Server 

   

 

=> Fill in details and choose correct mode

=> Select objects and click on Ok

and you are done.

 

Gateway is required to referesh data from power bi service. you can configure refresh schedule as per need :

 

 

 

You can select the refresh frequency on a regular schedule, e.g. daily, or customize to several time slots.

Enabling the scheduled refresh feature also allows you to perform a manual refresh on-demand

 

I hope this helps.

 

Cheers

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi, I mentioend that I got no luck with this connection. I tried houndrets times to go through it (as this is very similar to any other Power BI getting data step, which I do on a daily basis). The problem is with connection:

     

    1. Open Power BI => Get Data => SQL Server 

     

    but different errors appears. E.g. I have port number instead of server name (but I read this is the same and it does not matter), so when I put numers only, this is what I get:

     

     

     

    So i tired putting like "port:12345", this brings me to the next step, of adding cretindials.

     

    I have been given user and password so I put them:

     

     

     

    again this is what I got:

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi, Anonymous 

      I think you have to have the sql server name and port number. Here I take the sql server of my VM1 (port 1433) machine as an example.

      Here is the SQL Server server name to look for vm1:

      Now I'm connecting to VM1's sql server in my other machine:

      Format:

      servername,portNumber

      If you can connect to this sql server in SSMS, there is no problem. Next, let's connect it in Power BI desktop:

       

       

      Power BI desktop accesses our database as normal. In summary, you need to have the SQL Server server name and the corresponding port number, which is required.

       

       

      Best Regards

      Jianpeng Li

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