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 u...
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.

jcarville's avatar
jcarville
Skilled Sharer
7 years ago

That's what I did and it worked for me, deleting the dataflow and setting it up again, a bit of a pain I know

jason435's avatar
jason435
Helper II
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.

  • OscarIvanCampos's avatar
    OscarIvanCampos
    Helper I
    6 years ago

    Hi all, 

     

    I have the same issue and I have also done what you have suggested here. However, In my case it is still giviming this error. 

     

    Any other thoughts? Or I may be missing one step on my configuration.

     

    Any help would be really appreciated.

     

    Oscar