Forum Discussion
Helper Vexchange cannot be added to the Gateway
Hi Mates,
I have a cluster of data connections created by on-premise and accessible in Power Bi Service. As you can see in the attached photo, the only connection which is problematic is the 'MS Exchange' one which is setup in Desktop to refresh a dataset. However, this connection cannot be added to the Gateway making it impossible for the other connections in the same cluster.
Does anyone have any idea how to get rid of this or fix it? 🙂
Thanks
Alirezam , refer if these can help
https://community.powerbi.com/t5/Service/Gateway-Error-Cannot-be-added-to-gateway/m-p/571273
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKkHi Alirezam ,
If your dataset not only contains cloud data source but also the on premise data source, then you may tick the "Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster" option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
- amitchandak
Super User
Alirezam , refer if these can help
https://community.powerbi.com/t5/Service/Gateway-Error-Cannot-be-added-to-gateway/m-p/571273
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk- Alirezam
Hi, Not really. Tried to read through both articles which are not addressing my question.
v-xicaiCommunity Support
Hi Alirezam ,
If your dataset not only contains cloud data source but also the on premise data source, then you may tick the "Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster" option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Alirezam
Hi bro,
The data can not be merged or appended as they are totally different datasets. I tried to tick the boxes you said and the problem is still there. Thanks though
