Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Issues with Gateways, Source already existent but it continues to request it to be added

Seeing multiple issues with Gateways about that have started about a week ago. Please see this one, it appears there is a Bug.... This source was already working, but now it shows as if it needs to be added to the gateway. Once added again with a new name in source it will continue to show in gateway as if it needs to be added from sctratch. BUT this source had been here all along. Tested in 2 separate gateways. Source is an Excel file hosted in Sharepoint. 

  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous ,

    This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No: 360525736. Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

     

    Best regards,
    Community Support Team_Binbin Yu

10 Replies

  • You do not need to use a gateway for Microsoft cloud data sources (like your sharepoint list)  UNLESS you are merging that data source with an on-prem data source in Power Query (which you shouldn't do anyway).

     

    The "Add to gateway"  is only a suggestion, it is not required.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks lbendlin  the issue is the Gateway is grayed out and cannot be selected, possibly due to that the same message of 'add to gateway' continues within the Sources listed. You can see from my screenshot it cannot be selected. 

  • sunshine_1234's avatar
    sunshine_1234
    Frequent Visitor

    Hello All, I have the same issue... "Add to gateway" is not an option anymore... 

     

    I noticed this behaviour from the beginning of this year... 

    Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anonymous ,

    This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No: 360525736. Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

     

    Best regards,
    Community Support Team_Binbin Yu

    • Anonymous's avatar
      Anonymous
      Not applicable

      Is there anyway to check for updates on this issue to when it is resolved, having the same issue myself. Thanks

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User

        The issue persists, and it boils down to a disagreement on the connection string between the dialog that asks you to create the connection and the dialog that creates the connection (the latter omits the trailing forward slash that the former expects).  Short term remedy is to manually create the connection including the trailing forward slash.