Power BI Connection to DataVerse giving Error

Hi, Anonymous 

According to your description, a Power BI Desktop Refresh Error occurs when connecting to DataVerse and says "Unable to open a connection to SQL Server". You can try the following steps to resolve this problem.

1. Ensure that the SQL Server service is running on the host computer.
2. Verify that you are using the correct SQL Server instance name. Verify that SQL Server is configured to allow remote connections, you can check this in SQL Server Configuration Manager under "SQL Server Network Configuration".
3. Test basic network connectivity using commands to the SQL Server host. Check that the TCP port on which SQL Server is listening (1433 by default) is accessible using or similar network tools.
4. Ensure that the firewall on the server allows traffic on the SQL Server port. For the default instance it is usually TCP port 1433, for named instances make sure that the SQL Server Browser service is allowed through the firewall.
5. Check that named pipes and TCP/IP protocols are enabled in the SQL Server Configuration Manager.
6. Verify that your account has the necessary permissions for both SQL Server and DataVerse.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum