Forum Discussion
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 the token and try again...'. Anyone please help me how to over come this.
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.
6 Replies
HI Anonymous ,
What is the datasource you are connecting to in Power BI Desktop?
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.