I'm new to this setup, but I think I've all the steps complete. However when I attempt to connect to a SQL server from PowerBI Desktop it keeps failing.

Things checked so far:

PBI Service (in 365):

• under my admin account and user account, shows both OnPrem connected and online
• under my admin account and user account, shows connection to db both connected and online

OnPrem Data Connector:

• Shows all green for available connections,
• Diag test shows all tests successful,

Infrastructure:

• AzureAD joined Azure Virtual Server Microsoft Windows Server 2022
• OnPrem data connector on the AzureVM
• SQL Server 2019, with local admin windows user
• Local laptop not connected to server via network (as I want to use the data connector only)
• PowerBI Desktop on the Laptop, signed in with user account (not my admin one)

Tests:

• have installed PowerBI desktop on server and connected with the same credentials I'm trying via the laptop, and I can connect and pull data successfully.
• have tried with the admin credentials on local laptop and makes no difference.
• have made sure hostnames/names/spelling/caps are all the same across the setup/logins

Method:

• From desktop PBI I'm just 'GetData' form SQL Server, and entering the normal server hostname and db. I'm new to this so it's my understanding that as I'm logged in with my user 365 account, that an admin account has assigned 'share' permissions on both the OnPrem connector & Connection setup in the 365 PBI Service, that it should allow me to pull data. Apologies if I've got that wrong :-(

Error:

Details: "Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

Any help would be great, thanks.