Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DMTS_OAuthTokenRefreshFailedError

I tried to refresh dataset in power bi and since 2 weeks I have had the below error. What happened?   Data source error: {"error":{"code":"DMTS_OAuthTokenRefreshFailedError","pbi.error":{"code":"DM...
Need Help
  • GilbertQ's avatar
    GilbertQ
    4 years ago

    Hi Anonymous 

     

    It would appear that there is an issue with the device used during Authentication?

     

    If you could try and re-configure the authentication to SharePoint via the dataset settings, then data source settings?

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
4 years ago

Hi  Anonymous ,

 

The Azure Active Directory (AAD) OAuth token, used by many different data sources, expires in approximately one hour. You can run into situations where loading data takes longer than the token expiration (more than one hour), since the Power BI service waits for up to two hours when loading data. In that situation, the data loading process can fail with a credentials error.

 

Data sources that use AAD OAuth include Microsoft Dynamics CRM Online, SharePoint Online (SPO), and others. If you’re connecting to such data sources, and get a credentials failure when loading data takes more than an hour, this may be the reason.

 

Microsoft is investigating a solution that allows the data loading process to refresh the token and continue. However, if your Dynamics CRM Online or SharePoint Online instance (or other AAD OAuth data source) is so large that it can run into the two-hour data-load threshold, you may experience a data load timeout from the Power BI service as well.

 

Also note that, for refresh to work properly, when connecting to a SharePoint Online data source using AAD OAuth, you must use the same account that you use to sign in to the Power BI service.

 

In addition, if you want to connect to a data source from Power BI service using OAuth2, the data source must be in the same tenant as Power BI service. Currently, multi-tenant connection scenarios aren’t supported with OAuth2.

 

For more information, please refer to: Troubleshooting refresh scenarios - Power BI | Microsoft Docs

 

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.