Scheduled refresh failing with Invalid connection credentials in powerbi online

[rumittal]

Hi,

I had setup a scheduled refresh and its failing with below reason continously, eevn thgouh same credentials work fine when I refresh Dataset from desktop .

Can you please help with if its actually an issue with credential OR is it due to refresh running for longer duration ?

OR what is the way to root cause this ?

Invalid connection credentials. Refresh failed: BB_r1_tracking_v1 has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. Next refresh for BB_r1_tracking_v1 is scheduled for August 17, 2019 0:00 UTC.

Learn more >

Technical Information

Activity Id:

704ac6b8-53fb-443d-aa76-adfe3e1c0c1a

Request Id:

f57c8914-1ec7-42c1-a57b-ebe546dbb99b

Cluster Name:

DF-MSIT-SCUS-redirect.analysis.windows.net

Refresh Start Time:

August 15, 2019 18:32 UTC

Refresh End Time:

August 15, 2019 18:43 UTC

Last refresh failed: Sat Aug 17 2019 00:13:38 GMT+0530 (India Standard Time)
Invalid connection credentials.Hide details

Underlying error code:	-2147467259 Table: Team.
Underlying error message:	The credentials provided for the Web source are invalid. (Source at https://kusto.aria.microsoft.com/v1/rest/query.)
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:	Web
Microsoft.Data.Mashup.CredentialError.DataSourcePath:	https://kusto.aria.microsoft.com/v1/rest/query?db=de9b599503654d50ba07b5a40adf6afa&csl=.show%20versi...
Microsoft.Data.Mashup.CredentialError.Reason:	AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:	[{"kind":"Web","path":"https://kusto.aria.microsoft.com/v1/rest/query?db=de9b599503654d50ba07b5a40adf6afa\u0026csl=.show%20..."}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:	AccessUnauthorized
Cluster URI:	DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:	877fa9ea-1d3c-4411-a0cc-909bbee033cb
Request ID:	e7018504-d2f0-4934-8d1a-0a90d0e4a1cd
Time:	2019-08-16 18:43:38Z

[Anonymous]

Same problem - started happening yesterday.:

Last refresh failed: Wed Aug 21 2019 07:47:57 GMT-0500 (Central Daylight Time) 
The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.Hide details

Cluster URI:	WABI-US-EAST2-redirect.analysis.windows.net
Activity ID:	6b90ce4b-f657-40fa-be0a-74b324e514ab
Request ID:	54d1f1d5-0e5e-40b4-065f-32584b7a385e
Time:	2019-08-21 12:47:57Z

I am refreshing from a Dataflow.  The Dataflow is refreshing just fine, as are several other reports using the same Dataflow.

[rumittal]

@Anonymous, Thanks for the update!

Refresh failed in succession for each day it was trigegred for (please see below).

I am enabling the schedule again, will let you know if it fails again. 

Refresh history

ScheduledOneDrive

Details Type Start End Status Message

Show	Scheduled	8/17/2019, 12:02:11 AM	8/17/2019, 12:13:38 AM	Failed	Invalid connection credentials.
Show	Scheduled	8/16/2019, 12:02:11 AM	8/16/2019, 12:13:22 AM	Failed	Invalid connection credentials.
Show	Scheduled	8/15/2019, 12:03:12 AM	8/15/2019, 12:16:07 AM	Failed	Invalid connection credentials.
Show	Scheduled	8/14/2019, 12:02:10 AM	8/14/2019, 12:15:30 AM	Failed	Invalid connection credentials.

[rumittal]

@Anonymous, I am still getting the same refresh failure, it seems like a definitive refresh failure. As mentioned by you, I should contact the support.

Is there a separate forum ?

Invalid connection credentials. Refresh failed: BB_r1_tracking_v1 has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. Next refresh for BB_r1_tracking_v1 is scheduled for August 23, 2019 0:00 UTC.

Learn more >

Technical Information

Activity Id:

5c77ad3d-9d84-4fff-b9fa-1b83a2ea71aa

Request Id:

f2e040e3-60d7-44a0-a553-3f41c47e1590

Cluster Name:

DF-MSIT-SCUS-redirect.analysis.windows.net

Refresh Start Time:

August 21, 2019 18:33 UTC

Refresh End Time:

August 21, 2019 18:45 UTC

[Anonymous]

@rumittal  - I was able to resolve my problem last night.  Some time in the last couple days the privacy settings changed, and after restoring them everything is refreshing fine.  It was only on certain dataflows, and they were all previously set correctly and refreshing without issue.  I'm not sure what happened, but you might take a look at your permission settings to make sure they are still set correctly.

[Anonymous]

which privacy settings and how can i do the same?