Reports in service will not refresh after gateway credential update

[Bananathan]

I have updated the gateway credentials after refresh errors last night. However, after updating and pressing refresh, all the reports are stuck refreshing and it will not complete. They are still running now 2 hours later.

The reports have pretty small datasets and have never had an issue the past year that they've been published. I also cannot publish from the desktop - that seems to hang too.

Anyone experienced an issue like this before? It's very hard to figure out the problem when there is no error message!

[Bananathan · Accepted solution]

For anyone else that comes across this.

Restarting our gateway seems to have solved the issue

[sergej_og]

Strage behaviour...
I'm running in version 3000.226.5, no issues.

Hope you can fix it by restarting the client

[Bananathan]

Got a new error message - though just looks like a timeout: 

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Downstream service call failed with status code '403'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Error","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"TokenExpired"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorMessage","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestId","detail":{"type":1,"value":"b63b27d0-277f-40ee-a001-30dd085fa168"}}],"exceptionCulprit":1}}}

[Bananathan]

Hi, thank you for the reply.

I meant by update that I have changed the credentials today (and edited the credentials to upto date credentials for each gateway connection).

I am not sure what gateway version I am on - I noticed an update in July for Gateways - could that have caused the error?

Just an aside, seems I'm not the only one with this issue: https://community.fabric.microsoft.com/t5/Service/All-reports-are-stuck-at-refreshing-status/m-p/405...

Potentially restarting the gateway may fix it - I will speka to my IT admins and try this. Weird to see no word from Microsoft or nothing on the status page.

[sergej_og]

Hey @Bananathan 
what do you mean by "updating the gateway credentials"?
Which gtw version are you running?