Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data load error

Hi, while loading 196M data to power bi desktop, getting an error- '[datassource error] error[HY000] [microsoft][hardy](125) Token expired while fetching result. TEAuthTokenExpired. please update th...
Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    Hi Anonymous ,

     

    I guessed right then 🙂

    In Azure Databricks, there is a need to generate a token to connect to the the Hive tables.

    That token has a lifetime of certain days if I am correct. You will need to re-generate the token again and give that token in Power BI Desktop in your connection settings, then the connection will refresh correctly.

     

Pragati11's avatar
Pragati11
Super User
4 years ago

Hi Anonymous ,

 

I guessed right then 🙂

In Azure Databricks, there is a need to generate a token to connect to the the Hive tables.

That token has a lifetime of certain days if I am correct. You will need to re-generate the token again and give that token in Power BI Desktop in your connection settings, then the connection will refresh correctly.

 

Shelley's avatar
Shelley
Post Prodigy
3 years ago

Thanks. Could you also please share - how do we generate a token? I only know how to connect to our Databricks tables.