Forum Discussion

CraigBlackman's avatar
CraigBlackman
Helper III
11 years ago
Solved

Why do I get this error when refreshing a Dataset?

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 th...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    11 years ago

    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's avatar
CraigBlackman
Helper III
11 years ago

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's avatar
MSekhaolelo
Frequent Visitor
9 years ago

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