Why do I get this error when refreshing a Dataset?

[CraigBlackman]

I have recently added a dataset which I then removed as it was for testing. After reworking and reuploading, I am now getting this error message when i try to refresh the dataset. How do I resolve this?

Oops, something went wrong.

An error occurred while processing the data in the dataset.

Processing ErrorRetrieving the COM class factory for component with CLSID {C8B522D1-5CF3-11CE-ADE5-00AA0044773D} failed due to the following error: 800703fa Illegal operation attempted on a registry key that has been marked for deletion. (Exception from HRESULT: 0x800703FA).

Cluster URIWABI-NORTH-EUROPE-redirect.analysis.windows.net

Activity Id00515f69-d3a4-4586-91c5-148fef986688

Request Idbc6b1dcc-d4c6-c8e2-e718-7f7a94daf483

Time2015-08-20 11:20:35Z

[Greg_Deckler · Accepted solution]

Have you tried renaming your dataset to something else and then uploading? Long shot but might get you around this if something is cached. Is this an Excel file or PBIX file that you are uploading or are you using the data sources in the Service directly and what is the original source, DB, CSV, ?

Your best bet may be to send a "frowny face" when in the Service. It is the smiley face icon in the upper right. It allows you to describe the problem and take a screen shot. I have had VERY GOOD success when using this feedback mechanism. I generally receive a very timely reply from the support team.

[CraigBlackman]

Hi,

Its a PBIX which contain a couple of SQL queries, so nothing to complicated. I have managed to update the datasource name, but again the same issue.

I suspect its a caching issue as you manetioned, so i'll send the frown and see what comes back.

[MSekhaolelo]

Hi there

I have this error

Last refresh failed: Tue Feb 28 2017 09:33:04 GMT+0200 (South Africa Standard Time)
There was an error in the data gateway.Hide details

Underlying error message:	The server name provided doesn't match the server name on the SQL Server SSL certificate. Please see https://go.microsoft.com/fwlink/?LinkId=394782. (Source at zabrysvbiops01;EDW_ITO.)
Underlying error code:	-2147467259
Microsoft.Data.Mashup.CredentialError.Reason:	PrincipleNameMismatch
Microsoft.Data.Mashup.CredentialError.DataSourceKind:	SQL
Microsoft.Data.Mashup.CredentialError.DataSourcePath:	zabrysvbiops01;EDW_ITO
Cluster URI:	WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID:	ef6b1663-c4ea-466f-b05a-408e035640bc
Request ID:	28d6c104-8e63-443e-87bc-79e9088c8db7
Time:	2017-02-28 07:33:04Z