Forum Discussion

TomsNg's avatar
TomsNg
Helper I
2 years ago

Failed to load data from Dataverse

Hi experts,

I created a table through Power Apps. It is a Microsoft Dataverse table. I can see my table(ie, Pet table) under the selected environment. Next, I opened the Power BI Desktop and created a blank report, click the 'Dataverse' icon. There are four Dataverse folders. I selected the one contained the Pet table. However, after a long processing time, an error is returned. May I have your advice, pls?

 

 

 

Thanks

 

Toms

Need Help

1 Reply

  • TomsNg's avatar
    TomsNg
    Helper I
    2 years ago

    Hi Experts,

     

    Today, I saw a home page provided by Microsoft. It is about blocked port and ask to check the port of the RemoteAddress(ie, the environment IP). I checked that the port 1433 of the remote computer address is blocked, while port 5558 is connected successfully. I am not sure whether it is required both port 1433 and 5558 are enabled or just one port available is enough?

     

    Here is the command(a PowerShell command)

    Test-NetConnection -computername orgxxx.crm.dynamics.com -port 1433(failed)

    Test-NetConnection -computername orgxxx.crm.dynamics.com -port 5558(TcpTestSucceeded)

     

    Any advice, pls?

     

    Regards

     

    Toms