Forum Discussion

jcarville's avatar
jcarville
Skilled Sharer
7 years ago
Solved

Gateway Error - Cannot be added to gateway

Hi there,

 

I've configured an enterprise gateway that connects to a SQL Server and refreshed fine. I recently added a new data source using a Dataflow that connects to the same SQL Server and is using the same enterprise gateway, and am now getting the following error:

 

 

Has anyone else came across this error?

 

Thanks.

Need Help
Show and Tell
  • jcarville's avatar
    jcarville
    7 years ago

    I took my reports off the service, rebuilt the dataflow and uploaded them again. It seemed to have fixed the issue, still not sure what caused the failure but the classic on/off approach has saved the day again.

  • jason435's avatar
    jason435
    7 years ago

    Thanks.

     

    I took a different approach. Too troubleshoot, I turned off all the 'include in report refresh" in power query for the tables connected to a dataflows. Uploaded and to and check to see if refresh worked. It did. Then I turned them all back on, and everything worked.

     

    Dataflows are still in beta, seems to be a bug. But at least now I can combine data from multiple excel online spreadsheets.

11 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Is this new source on the same SQL Server but within a different database?  If so, you'll need to configure another gateway connection for this database.

    • jcarville's avatar
      jcarville
      Skilled Sharer
      7 years ago

      Hi Anonymous, appreciate the reply.

       

      Both of the sources are within the same database and I have a Pro account.

      • jcarville's avatar
        jcarville
        Skilled Sharer
        7 years ago

        Could it have anything to do with permissions and privacy levels? Both data sources have a privacy level of organisational and the gateway also has organisational as its privacy level.

  • KilianM's avatar
    KilianM
    Frequent Visitor
    5 years ago

    I tried the two solutions you presented (as i understood) :

     

    - Turned off all the 'include in report refresh" in power query for the tables connected to a dataflows. Uploaded and to and check to see if refresh worked. It did. Then I turned them all back on, and everything worked.

     

    - Took my reports off the service, rebuilt the dataflow and uploaded them again

     

    None of these two propositions solved the issue. Are there new solutions you found recently ?

     

    Thanks

    Best regards,

    Kilian

     

  • karo's avatar
    karo
    Advocate V
    5 years ago

    Hi,

     

    Any new solutions came up? rebuilding dataflows is not a friendly one...

     

    regards,

    karo