Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
joerykeizer
Helper II
Helper II

Enterprise gateway: "Cannot connect to the mashup data source"

Hi all,

 

I've been unable to properly use the enterprise gateway for about a month now so I could really use some help.

 

Failure message: Cannot connect to the mashup data source.

 

Underlying error message: 8/10 times: We're sorry, an error occurred during evaluation. 2/10 times: Microsoft SQL: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)

 

On the latter message it does show which server (IP) is causing the error. It's from a specific IP but the server name varies between the ones used in the dataset. I don't see anything wrong with them personally.

 

 

What I have tried and didn't work:

- Updating the gateway

- Reinstalling the gateway

- Republishing and overwriting the reports

- Completely removing and republishing the reports

- Check server credentials and access privileges

- Limit every table to one row to see if model size was a problem

 

What does work:

- Refresh in PowerBI desktop

- Gateway shows online and good to go

- Refresh individual datasets with 1 source (also in Direct Query)

- Refresh serveral test reports with multiple sources

 

I have gotten some files to succesfully refresh after deleting multiple sources but it might as well be completely random because I can't pinpoint what exactly is causing the refresh to fail.

 

Some help would be very much appreciated!

6 REPLIES 6
v-shex-msft
Community Support
Community Support

Hi @joerykeizer,

 

Can you ensure your data sources all support to update with enterprise gateway?

If you can please provide some detail content of your issue, it will help for troubleshooting. (e.g. refresh history, error log, source list, ...etc)

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

@v-shex-msft

I have the same issue...

 

Last refresh failed: Fri Jun 30 2017 17:06:41 GMT+0300 (Russia TZ 2 Standard Time) 
Cannot connect to the mashup data source. See error details for more information.Hide details
Underlying error code:	-2147467259
Underlying error message:	AnalysisServices: Произошла следующая системная ошибка:
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind:	AnalysisServices
Microsoft.Data.Mashup.ValueError.DataSourcePath:	bi2;FT_CUBE
Microsoft.Data.Mashup.ValueError.Reason:	DataSource.Error
Cluster URI:	WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID:	56fc5fe5-c8b4-479c-98f4-5082dadf30e4
Request ID:	8d5322fe-38dd-4dbb-a662-f1d1ce343579
Time:	2017-06-30 14:06:41Z
Anonymous
Not applicable

@v-shex-msft

 

Have you found  a solution for this? I've got the same issue

joerykeizer
Helper II
Helper II

@malagari No I'm not using any parameters.

 

@kcantor The gateway was re-downloaded and installed last week so I would assume so. Current version is 1.15.6170.1. Is there any way to check what the lastest version is? I can't find it on the website.

kcantor
Community Champion
Community Champion

@joerykeizer

Have you installed the latest gateway? I had the same issue and my gateway was one behind.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




malagari
Responsive Resident
Responsive Resident

Any chance you are using parameters in your data sources?

Dan Malagari
Consultant at Headspring

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors