Forum Discussion

cmikos's avatar
cmikos
Helper I
8 years ago
Solved

Can't connect to SQL Server named instance

I can't connect to my SQL Server named instance with Power BI Desktop (October 2017)   I can only connect if I don't specify the instance name but then my datasource gets published without it and c...
Need Help
  • cmikos's avatar
    cmikos
    8 years ago

    I figured out the issue, it was UDP port 1434 for the SQL Browser, non-standard, usually TCP 1434 is enough

Anonymous's avatar
Anonymous
Not applicable
8 years ago

cmikos，

Do you connect to the SQL Server using the machinename\MSSQLSERVER or servername\MSSQLSERVER connection string? If that is the case, MSSQLSERVER is for default instance, hence just provide the server name(machine name) alone in the connection string  and don’t use \MSSQLSERVER.

After you publish the PBIX file to Power BI Service, make sure that you enter same server name and database name as that you use in Power BI Desktop when adding SQL data source within gateway, then you are able to use gateway to refresh your dataset.

Regards,
Lydia

  • cmikos's avatar
    cmikos
    Helper I
    8 years ago

    I figured out the issue, it was UDP port 1434 for the SQL Browser, non-standard, usually TCP 1434 is enough