cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jcarville Skilled Sharer
Skilled Sharer

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:

 

Capture2.PNG

 

Has anyone else came across this error?

 

Thanks.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
jcarville Skilled Sharer
Skilled Sharer

Re: Gateway Error - Cannot be added to gateway

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.

View solution in original post

jason435 Helper II
Helper II

Re: Gateway Error - Cannot be added to gateway

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.

View solution in original post

9 REPLIES 9
Ross73312 Community Champion
Community Champion

Re: Gateway Error - Cannot be added to gateway

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 Skilled Sharer
Skilled Sharer

Re: Gateway Error - Cannot be added to gateway

Hi @Ross73312, appreciate the reply.

 

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

jcarville Skilled Sharer
Skilled Sharer

Re: Gateway Error - Cannot be added to gateway

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.

Ross73312 Community Champion
Community Champion

Re: Gateway Error - Cannot be added to gateway

Based on that, everything should be ok.  There must be something else at play.

Highlighted
jcarville Skilled Sharer
Skilled Sharer

Re: Gateway Error - Cannot be added to gateway

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.

View solution in original post

jason435 Helper II
Helper II

Re: Gateway Error - Cannot be added to gateway

I'm getting this error as well. What do you mean by rebuild the dataflow? Delete the dataflow and set it up again? And then reconnect your report to the dataflow.

 

A bit of hasstle for me to re setup my dataflows.

jcarville Skilled Sharer
Skilled Sharer

Re: Gateway Error - Cannot be added to gateway

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 Helper II
Helper II

Re: Gateway Error - Cannot be added to gateway

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.

View solution in original post

Re: Gateway Error - Cannot be added to gateway

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

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.