Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.