Forum Discussion

bhawnaA's avatar
bhawnaA
Frequent Visitor
2 years ago

Power BI Gateway Issues

HI Team ,

I am using majorly 2 Data Sources  
1. SQL server 
2. CRM (Dataverse) 
I have a on premise gatway installed for the SQL server DS which is working fine . 
But i am getting a connectivity error while connecting to CSD . 

This is a critical issue. All the help is appreciated .

 

 

 

Need Help
Tips and Tricks

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    What exactly is the issue?  You need to map your SQL server connection. Use the dropdown, then Apply.

    • bhawnaA's avatar
      bhawnaA
      Frequent Visitor
      2 years ago

      lbendlin 
      Thanks for the reply ! but as displayed in the images the above , The issue is not the SQL . As Stated the Sql server connection works Fine . The issue is with the CDS connectivity .
      When i try to add Dataverse URL by clicking on manually add to Gateway and create new connection it doesnt get attached to the Dataverse Connection

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Are you trying to merge these data sources in Power Query?