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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
neonguyen
Frequent Visitor

Refresh fail and get error : The following system error occurred: Type mismatch

I have a report and set schedule refresh for it. Few days ago, still working fine, but from July 1, i got error as below:

 

"Something went wrong

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these details.

Processing error: The following system error occurred:  Type mismatch.  Unable to convert a value to the data type requested for table 'SEC_2019_Enrollment' column 'SEC ID'. The data provider was unable to convert the value '[Table]' from the source data type 'VT_BSTR' to the expected data type 'VT_I8'. Please check the column data types in the data model and data source and ensure that the data types are compatible.  Table: SEC_2019_Enrollment.

Cluster URI: WABI-EAST-ASIA-A-PRIMARY-redirect.analysis.windows.net

Activity ID: acb4bfb4-5cc7-4cda-bd6a-9ba6ebea7c88

Request ID: 8e81cbde-ddec-fd76-2959-76e38f64b796

Time: 2019-07-02 09:31:23Z"

 

And sometime i got other error as below:

Message:

The command has been canceled. Table: Deal.

Cluster URI:

WABI-EAST-ASIA-A-PRIMARY-redirect.analysis.windows.net

Activity ID:

acb4bfb4-5cc7-4cda-bd6a-9ba6ebea7c88

Request ID:

d69a7b5f-f1f9-bf8e-03fc-a668c7722f80

Time:

2019-07-02 08:26:46Z

 

Few days ago still working fine:

AwesomeScreenshot-Power-BI-2019-07-02-22-07-13.png

Anyone have ideas about that? I don't know what I need to fix/change. 

 

Thanks for your reading about my article

 

1 ACCEPTED SOLUTION
v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @neonguyen ,

Do you have the refresh when you click Refresh button in Power BI Desktop?

In addition, have you changed some data type in your data source recently?

Based on the error message, please check the table columns type in SEC_2019_Enrollment .

Besides, there is a similar issue which has been solved you could refer to.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

I have this error:

 

Feedback Type:
Frown (Error)

Error Message:
ExecuteXmla failed with result

Stack Trace:
Microsoft.PowerBI.Client.Windows.AnalysisServices.XmlaExecutionException
en Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.ExecuteXmla(String xmla)
en Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.<>c__DisplayClass45_0.<ImageLoadDatabaseFromPbix>b__0()
en Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService.OnErrorClarify(Action action, String clarification)
--- Fin del seguimiento de la pila de la ubicación anterior donde se produjo la excepción ---
en System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
en Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Stack Trace Message:
ExecuteXmla failed with result

Invocation Stack Trace:
en Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
en Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
en Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.96.701.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesService","Error":"Microsoft.PowerBI.Client.Windows.AnalysisServices.XmlaExecutionException - PFE_SYSTEM","MethodDef":"ExecuteXmla","ErrorOffset":"112"}

InnerException0.Stack Trace Message:
The following system error occurred:


InnerException0.Stack Trace:


InnerException0.Invocation Stack Trace:
en Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
en Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromException(Exception e, String prefix)
en Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.GetFeedbackValuesFromInnerExceptions(Exception e, Int32 depth)
en Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo.CreateAdditionalErrorInfo(Exception e)
en Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception, Nullable`1 stackTraceInfo, String messageDetail)
en Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass15_0.<HandleException>b__0()
en Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
en Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
en Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError_ErrorDescription:
PFE_SYSTEM

PowerBIUserFeedbackServices_IsReported:
True

Anonymous
Not applicable

Error devuelto: 'The following system error occurred:

v-piga-msft
Resident Rockstar
Resident Rockstar

Hi @neonguyen ,

Do you have the refresh when you click Refresh button in Power BI Desktop?

In addition, have you changed some data type in your data source recently?

Based on the error message, please check the table columns type in SEC_2019_Enrollment .

Besides, there is a similar issue which has been solved you could refer to.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors