Forum Discussion
Gateway authentication expires every two weeks
Hi,
We have an on-prem gateway setup to our Azure Data lake,
Everything works fine after authenticating my credentials under "Manage Connections and Gateways".
However, I noticed that every two weeks my authentication on the gateway expires and the dataset/semantic model fails to refresh and the error is related the authentication on the gateway. I then have to reauthentication my credentials on the gateway for the dataset/semantic model refreshes fine.
FYI my credentials have never changed.
Have this happened to anyone before? Is there a solution for me not to reauthenticate every two weeks?
Here's the error Im getting:
- Data source error{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the AzureDataLakeStorage source are invalid. (Source at XXXXX.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"AzureDataLakeStorage"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"XXXXX"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"AzureDataLakeStorage\",\"path\":\"XXXXX\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: Transaction.
- Cluster URIWABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net
- Activity IDb5a81f61-6c93-4421-8701-a83aa58cf8f1
- Request IDcb27bdb9-17dc-4fc3-ad54-ba5dc0bb55ea
- Time2024-03-16 21:03:16Z
I would greatly appreciate any input.
This has been resolved by updating the gateway and implementing a service principal account.
hope that helps.
5 Replies
Hi, casperlow
Based on your description, you are experiencing an issue with gateway authentication expiring every two weeks, causing dataset and semantic model refreshes to fail.
The error message you're encountering ("Invalid JWT Token. The token is expired.") suggests that the authentication token provided by your credentials is expiring. If possible, consider extending the token lifecycle. However, please be careful not to compromise security by setting the duration too long.
Related links:
Configurable token lifetimes - Microsoft identity platform | Microsoft Learn
Set lifetimes for tokens - Microsoft identity platform | Microsoft LearnBest Regards,
Yang
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thanks, for your response.
I'll investigate on the error further if it gets this error "Invalid JWT Token. The token is expired."Regards,
Casper
Please see error above on the description. I've edited my post.
casperlow Did you ever get this figured out?
