Forum Discussion
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 this?
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.
3 Replies
- Greg_DecklerCommunity Champion
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.
- CraigBlackmanHelper III
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.
- MSekhaoleloFrequent Visitor
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 detailsUnderlying 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