Forum Discussion
Web url data (table on sharepoint) refresh - credentials error on enterprise gateway
We are kinda speculating here to rescue you through your issue as it is not really clear what the reason might be. However i can suspect a versions non compatibility along the process of refreshing your report. could be the sharepoint, the Gateway or the desktop.
So give it a last try and install a personal Gateway( your machine has to be 64 bits) in your computer and use it. If it works then the entreprise Gateway needs to be updated, else the sharepoint or your desktop.
Hope this will save you.
Hi Anonymous
Try to edit the Web credentials to Ananymous and None
Tried Anonymous/None setting:
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.
Data source error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided cannot be used for the Web source. (Source at https://epodatelna.-------.cz/_layouts/15/WrkSetng.aspx.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Web"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://epodatelna.-----.cz/_layouts/15/WrkSetng.aspx?List=34cc8f13-cf2f-47a7-a269-458b55f6f8e3"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"CredentialInvalid"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Web\",\"path\":\"https://epodatelna.-----.cz/_layouts/15/WrkSetng.aspx?List=34cc8f13-cf2f-47a7-a269-458b55f6f8e3\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"CredentialInvalid"}}],"exceptionCulprit":1}}} Table: Query1.
Cluster URI: WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 7a7e8d69-dcb6-41ed-b8f3-43f2132500f0
Request ID: 6f52e115-fb4d-0290-5066-f0453567454a
Time: 2020-07-01 14:50:10Z
Im confused, how is it possible that desktop version is refreshing without problem .. ?
also, thank you for suggestion.
The Power bi desktop is free and doesn't use Gateway to connect to the source.
The Power service might need a Pro license to achieve some requests.
Do you have a Pro license?
Yes, I do.
We are kinda speculating here to rescue you through your issue as it is not really clear what the reason might be. However i can suspect a versions non compatibility along the process of refreshing your report. could be the sharepoint, the Gateway or the desktop.
So give it a last try and install a personal Gateway( your machine has to be 64 bits) in your computer and use it. If it works then the entreprise Gateway needs to be updated, else the sharepoint or your desktop.
Hope this will save you.