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 connecti...
Need Help
Tips and Tricks
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?

      • bhawnaA's avatar
        bhawnaA
        Frequent Visitor
        2 years ago

        Yes , In some cases Yes ! lbendlin