Dataverse issue transforming data

(2) Share

Report

Posted on by AT-14031646-0

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 https://xxxxxxxxxxx.crm4.dynamics.com/tools/diagnostics/diag.aspx 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 ?

Categories:

Dynamics 365 general

image.png

All responses (2)

Answers (0)

AT-14031646-0 6 on at

Like (0)

Report

Dataverse issue transforming data

Yes the user is admin to the environment.
Suggested answer

Tom_Gioielli 1,437 on at

Like (0)

Report

Dataverse issue transforming data

Have you confirmed that the credentials being used to authenticate with the Dataverse connection have permissions to the environments? If they do not have any security role assigned, the environments would appear as inaccessible when attempting to connect.