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 

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Please don't.  As soon as you merge on-prem and cloud data sources in Power Query bad things will happen

         

        - you need to set your gateway to allow refresh of cloud data sources

        - you need to add the cloud data source to the gateway

        - you can never go back from that

         

        So please don't.