cancel
Showing results for 
Search instead for 
Did you mean: 

Scheduled refresh failing with Invalid connection credentials in powerbi online

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
Status: New
Comments
Visitor

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.

Regular Visitor

@stephcturner, 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
Scheduled8/17/2019, 12:02:11 AM8/17/2019, 12:13:38 AMFailedInvalid connection credentials.
Show
Scheduled8/16/2019, 12:02:11 AM8/16/2019, 12:13:22 AMFailedInvalid connection credentials.
Show
Scheduled8/15/2019, 12:03:12 AM8/15/2019, 12:16:07 AMFailedInvalid connection credentials.
Show
Scheduled8/14/2019, 12:02:10 AM8/14/2019, 12:15:30 AMFailedInvalid connection credentials.
Regular Visitor

@stephcturner, 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

Visitor

@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.