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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Azure databricks

  • 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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you, It help's.

       

      • tylesftw's avatar
        tylesftw
        Helper II
        3 years ago

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

    • 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.