topic Re: Data source error in Report Server

Data source error

siva506 — Tue, 22 Nov 2022 14:24:20 GMT

I am getting above error please help me for this

Re: Data source error

Anonymous — Wed, 23 Nov 2022 02:11:05 GMT

Hi siva506 ,

Please try below ways:

1. Please check your configurations, confirm it is correct

2. Please try to upgrade your gateway or uninstall and install a new gateway

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Data source error

siva506 — Fri, 25 Nov 2022 19:31:49 GMT

Hi,

I need help with the issue below.

Please help me.working fine on the desktop but problem in service only.

Last refresh failed: 11/24/2022, 10:11:55 PM
There was an error when processing the data in the dataset.Hide details

Data source error:	{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"AnalysisServices: The connection either timed out or was lost."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"AnalysisServices"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"canatec1v4621.na.loreal.intra\\boost;Boost_Local"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: UPC ASP.
Cluster URI:	WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID:	434c9d45-659b-4d24-91e2-a2deae519e83
Request ID:	4dac45b1-9228-ab6c-0f6c-c2ee30aa473d
Time:	2022-11-24 16:41:55Z

Re: Data source error

Anonymous — Fri, 02 Dec 2022 07:54:12 GMT

Hi siva506.,

Please try below steps:

1. please confirm that your datasource in gateway set correctly

2. please restart the gateway

3. if all operations do not work, pleaase try to uninstall and reinstall a new gateway to have a try

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.