LavinaVRovine's avatar
LavinaVRovine
Frequent Visitor
8 years ago
Status:
New

Web connector & google sheets &credentials

Hi,   for the past 2 weeks, I am experiencing trouble with refreshing google spreadsheet source. The PBI service and desktop seem to be having difficulties remembering credentials, which is intere...
Reports
LavinaVRovine's avatar
LavinaVRovine
Frequent Visitor
8 years ago

Hi,

 

i've setup the gateway as u've mentioned, which seems to fix the issue. 

 

Thank you

 

PS.

 

Hello,

 

it seems, that it did not help. I've setup gateway with anonymous access, Here is the error i've got (with downloadable url aswell)

 

Last refresh failed: Tue Aug 07 2018 13:48:00 GMT+0200 (Central European Summer Time)
Invalid connection credentials.Hide details
Underlying error code: -2147467259 Table: Azor.
Underlying error message: Přihlašovací údaje zadané pro zdroj Web jsou neplatné. (Zdroj v https://docs.google.com/spreadsheets/d/e/2PACX-1vQTEw5KzKmwxKwFbqQvS35RfPsg4wLSJWZKS8fMkwK7LJSg-Fid2...)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: Web
Microsoft.Data.Mashup.CredentialError.DataSourcePath: https://docs.google.com/spreadsheets/d/e/2PACX-1vQTEw5KzKmwxKwFbqQvS35RfPsg4wLSJWZKS8fMkwK7LJSg-Fid2...
Microsoft.Data.Mashup.CredentialError.Reason: AccessForbidden
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Web","path":"https://docs.google.com/spreadsheets/d/e/2PACX-1vQTEw5KzKmwxKwFbqQvS35RfPsg4wLSJWZKS8fMkwK7LJSg-Fid2..."}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessForbidden
Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net
Activity ID: bc28fc15-aebb-402e-b5b5-acc156070f25
Request ID: 2dd75591-2f3a-41c9-2889-a32c7972bb37
Time: 2018-08-07 11:48:00Z

 

Completed Ideas