Forum Discussion

radoslavov91's avatar
radoslavov91
Regular Visitor
1 year ago
Solved

On-Prem connection not working

Hi All,   I need your help with a matter that i have and i cannot find a solution anywhere or don't know where to start from troubleshooting this.   We used to work with an external company that ...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    you made the unfortunate decision to merge your on-prem and your cloud data sources in Power Query. That now requires the cloud data source to be refreshed through the gateway.  However your gateway configuration has that setting "Allow cloud data sources to be refreshed through this gateway"  switched off.

     

    Best advice would be to start over, without merging (instead using the data model joins), so that the cloud data source does not need the gateway.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

you made the unfortunate decision to merge your on-prem and your cloud data sources in Power Query. That now requires the cloud data source to be refreshed through the gateway.  However your gateway configuration has that setting "Allow cloud data sources to be refreshed through this gateway"  switched off.

 

Best advice would be to start over, without merging (instead using the data model joins), so that the cloud data source does not need the gateway.