An error occurred while processing the data in the dataset.

Lidou_Cand · ‎07-02-2020

Hello,

I encounter problems when refreshing the dataset.
The gateway looks OK.
the day before I created a parameter on the connection.
I wonder if that could be the cause.
Have you ever encountered this error?

Data source error:	{"error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","pbi.error":{"code":"DM_GWPipeline_Gateway_SpooledOperationMissing","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Ptf.
Cluster URI:	WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID:	3da980a2-8e06-47a9-b467-d550e0f01658
Request ID:	9868f161-c3b6-6f7a-d267-455b8e7413a3
Time:	2020-07-01 16:47:51Z

Mariusz · ‎07-02-2020

Hi @Lidou_Cand

It looks like the parameter is the issue, it's stated in the text of the error msg.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

Lidou_Cand · ‎07-02-2020

Hello,

Thanks for your help.

I will test it.

Thanks

Lidou_Cand · ‎07-02-2020

Hello, I restarted the refresh of the report and now I have this error message. Does that mean anything to you?

An error occurred while processing the data in the dataset.

Refresh failed:

FIM_PRD_Combined has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

{"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: A connection cannot be made. Ensure that the server is running."}},{"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":"xw12lapp0021;FO_IPM_REPORTING"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: Ptf.