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
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.

      • bhawnaA's avatar
        bhawnaA
        Frequent Visitor
        2 years ago

        i am merging two tables ( both of them from datverse ) 
        also i have enabled  refresh of cloud data sources

        When i manually try to add the cloud data source to gateway it gets added and appears in the connections but it doesnt get mapped as in it doesnt appear in the box or in  the drop down