I couldn't connect using the provided connection string format. After some experimentation I was able to connect using this for a Server Name field:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=port_num))(CONNECT_DATA=(SERVICE_NAME=service_name)))
Please correct the documentation!
⚠Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.
Thanks for your comment, @sloggiz. We’ve forwarded your feedback to the writer, who should respond to this thread.
Thanks for the help! I've added a note to that article, so others can benefit from your post. Thanks! Should show up in a day or so.
When I try this, PowerBI tells me "The server name cannot have more than 128 characters", so this documentation does not help me.
What eventually worked for me for "Server" was ... HOST_NAME:PORT_NUM/SERVICE_NAME
Thank you all!
Thanks @lynchmob98 for the last tips!