Forum Discussion

dettenwangerk's avatar
dettenwangerk
Frequent Visitor
3 years ago
Solved

Dataflow refresh error on >35 mil rows

Hello,

 

I'm getting a error on my Power BI dataflow refresh: DataSource.Error: ERROR [HY000] [Microsoft][Hardy] (125) Token expired while fetching results: TEAuthTokenExpired. Please update the token and try again.
My data source is databricks, tables are updated incrementally and am using OAuth2 authentication. It refreshses in service for about an hour then times out. Has anyone ran into this with this type of setup and remedied?

 

Thanks!

Dataflow
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , dettenwangerk 

    The Azure Active Directory (Azure AD) OAuth token, used by many different data sources, expires in approximately one hour. 

     If you’re connecting to such data sources, and get a credentials failure when loading data takes more than an hour, OAuth might be the reason.

    Azure AD tokens are valid for 60 minutes by default. If the Import query is expected to take longer than 60 minutes, it is recommended that the refresh be done with a Personal Access Token (PAT) rather than an Azure AD credential.

    So, you can try other authentication methods.For more Information, you can refer to :

    Troubleshoot refresh scenarios - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

2 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi , dettenwangerk 

    The Azure Active Directory (Azure AD) OAuth token, used by many different data sources, expires in approximately one hour. 

     If you’re connecting to such data sources, and get a credentials failure when loading data takes more than an hour, OAuth might be the reason.

    Azure AD tokens are valid for 60 minutes by default. If the Import query is expected to take longer than 60 minutes, it is recommended that the refresh be done with a Personal Access Token (PAT) rather than an Azure AD credential.

    So, you can try other authentication methods.For more Information, you can refer to :

    Troubleshoot refresh scenarios - Power BI | Microsoft Learn

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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