Forum Discussion

isam2003's avatar
isam2003
Helper I
1 year ago

Error with accessing data from Dataverse

Hello:  My employer recently migrated to Dynamics 365 CRM.  I am trying to connect to the Dataverse from Power BI but keep running into errors.  

1)  I tried pulling in the same table from the Dataverse using both Import & Direct Query - I was able to successfully open the table in Import mode but not in Direct Query (refer  image below)


2)  I tried opening the table in Power Query but ran into another error (refer attached image 2) for both Import as well as Direct Query. 

 


I would appreciate your guidance with trying to resolve this issue. Thanks in advance. 



3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi isam2003 ,

     

    Try to clear the Dataverse credentials and connect again using direct query mode, if it still doesn't work, check if TCP port 1433 or 5558 is blocked.

    Power Query Dataverse connector - Power Query | Microsoft Learn

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

    • isam2003's avatar
      isam2003
      Helper I

      Thanks Anonymous 

       

      I will check it out and report back. 

    • isam2003's avatar
      isam2003
      Helper I

      Hi Anonymous 

       

      The IT team did not find any blocks in the listed ports. Thanks