Dataflow refresh error on >35 mil rows

[dettenwangerk]

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!

[v-yueyunzh-msft · Accepted solution]

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

[lbendlin]

Is this on Shared capacity or on Premium?