exchange cannot be added to the Gateway

[Alirezam]

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

[amitchandak · Accepted solution]

@Alirezam , refer if these can help

https://community.powerbi.com/t5/Service/Gateway-issue-with-Exchange-and-on-prem-SQL-Server/m-p/8315...

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

[Anonymous]

Hi Alirezam, I know that you had this question long time ago, but for others it could help. I had the same issue. Solved with Dataflows. Try the Exchange dataset connect by dataflow and then this dataflow connect to the dataset.

[v-xicai · Accepted solution]

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

[amitchandak · Accepted solution]

@Alirezam , refer if these can help

https://community.powerbi.com/t5/Service/Gateway-issue-with-Exchange-and-on-prem-SQL-Server/m-p/8315...

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.