Do we know what ports and services are needed for dataverse to work properly to transform data from Power BI Desktop app. We are constantly getting the error "A Network-related or instance-specific error occured while estabilishing the connection to SQL server. We are able to see the tables but unable to transform them completely.
Tried diagnostic tools and returned connection fine; also tried turning off TDS and turn back on from power platform admin center. Clearing the permissions also did not do the trick.
From the client side i have port TCP 443, 1433 and port 5558 open. Are there are any other required ports ? we also use a proxy in our environment but *.dynamics.com is whitelisted to not inspect the traffic for this environment.
Any suggestions on where to look next ?
