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 interesting, as the spreadsheet is published to the web, so its accessible to everybody having the URL.
When I come to the service, schedule refresh and go to the data credentials tab, there are no "crosses", ie it seems, that PBI "remembers" the (anonymous...) credentials. As soon as I hit the "refresh now" button, the page also refreshes (as ctrl+r) and the wild cross appears, telling me, that PBI does not know the credentials. After selecting the anonymous option, everything repeats.
The issue happens for multiple spreadsheets and PBI reports.
The refresh history provides this issue description:
Show Scheduled 8/4/2018, 12:02:04 AM 8/4/2018, 12:15:14 AM Failed There was an error when processing the data in the dataset.
While "show details" provides this information:
Message: The credentials provided for the Web source are invalid. (Source at https://docs.google.com/spreadsheets/............./pub.) Table: LeadSources. Cluster URI: WABI-WEST-EUROPE-redirect.analysis.windows.net Activity ID: dcc9a58b-8858-4de9-8986-cd31f8f4bc2a Request ID: f9419cce-cc28-4c8f-9414-d4ad7e9ddd87 Time: 2018-08-03 22:15:14Z
Strangely enough, sometimes (like twice a week on daily refresh), it even refreshes normally...
Anybody having the same issue or could provide any information whatsoever?