Data load error

[Rambabuv1493]

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.

[Rambabuv1493]

Azure databricks

[Pragati11 · Accepted solution]

Hi @Rambabuv1493 ,

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]

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

[Rambabuv1493]

Thank you, It help's.

[tylesftw]

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

[Pragati11]

HI @Rambabuv1493 ,

What is the datasource you are connecting to in Power BI Desktop?