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
Icon for Super User rankSuper 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.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you, It help's.

 

  • tylesftw's avatar
    tylesftw
    Icon for Helper II rankHelper II
    3 years ago

    Hi Ramba - where did you put the token when you generated it?