Forum Discussion

Violet's avatar
Violet
New Member
8 years ago
Solved

Cannot schedule refresh dataset from SQL Server because of server port

When I use Power BI Desktop to get data from SQL Server, I use the form of 'servername : portnumber' to connect to database. Then I publish the report to Power BI on the web.   I can refresh my dat...
  • Anonymous's avatar
    Anonymous
    8 years ago

    Violet,

    Please change your server name to "Servername,portnumber" format in Power BI Desktop. In order to successfully refresh the dataset in Power BI Service, the connection strings(server name, database name) should match between Power BI Desktop and gateway.


    Regards,
    Lydia

Violet's avatar
Violet
New Member
8 years ago

Hi Lydia,Anonymous

 

I tried this way before, but I cannot connect to the SQL Server if I use "Servername,portnumber" format.

Is there any configuration I need to change?

 

Best regards,

Violet

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Violet,

What error message do you get? Are you able to use the servername, port format in SSMS? Everything works in my Power BI Desktop.


Regards,
Lydia

  • Violet's avatar
    Violet
    New Member
    8 years ago

    Anonymous,

     

    Oh, I can connect to the database.

     

    Thanks,

    Violet