You’re offline. This is a read only version of the page.
Announcements
40
Hi All,
I am having some trouble getting Power BI to connect to one of my Power Platform Environment's Dataverse. I have access to two environments, each with a Dataverse, but only the Dataverse of one of them is accessible. Both have TDS Endpoint enabled. They produce different results when pinging from the same instance of PowerShell.
Share
ReportPS C:\Users\jleonard> Test-NetConnection -ComputerName my-dev.crm.dynamics.com -port 1433
ComputerName : my-dev.crm.dynamics.com
RemoteAddress : 13.83.64.166
RemotePort : 1433
InterfaceAlias : Ethernet 4
SourceAddress : 10.154.131.205
TcpTestSucceeded : True
PS C:\Users\jleonard> Test-NetConnection -ComputerName my-prod.crm.dynamics.com -port 1433
WARNING: TCP connect to (52.224.203.192 : 1433) failed
WARNING: Ping to 52.224.203.192 failed with status: TimedOut
ComputerName : my-prod.crm.dynamics.com
RemoteAddress : 52.224.203.192
RemotePort : 1433
InterfaceAlias : Ethernet 4
SourceAddress : 10.154.131.205
PingSucceeded : False
PingReplyDetails (RTT) : 0 ms
TcpTestSucceeded : False
What steps can I take to enable Power BI for my prod environment?
Thanks,
Jared Leonard
Hi @JLeonard,
I assume you have looked at this page? To isolate the issue, can you try to connect and execute a query not with Power BI but with SQL Server Management Studio as per the link? If it doesn't work then not likely an issue with Power BI but with the environment or firewall/proxy of your organization.
Hope this helps...
All responses (
Answers (
