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

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