Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
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
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
Have you installed the latest gateway? I had the same issue and my gateway was one behind.
Proud to be a Super User!
Any chance you are using parameters in your data sources?