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

[neonguyen]

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:

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

Thanks for your reading about my article

[GilbertQ]

Hi there

Was it possible that you uploaded a new version of the PBIX, which has got new Power Query functions used in steps?

If so those new Power Query functions might not be available in the On-Premise Data Gateway until it is updated.