Access token expired: Token is expiring within 30 second error

[biuser98]

Hi.

I have a dataset in a premium workspace which is around 6 gb in size. I have implemented incremental refresh in the desktop version and published the dataset to the service. The issue is that the dataset is not refreshing in the service.  

It throws the following error:
Access token expired: ODBC: ERROR [08006] [Microsoft][ThriftExtension] (10) Access token expired: Token is expiring within 30 seconds. (token expired)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"......}........

.....

The source data is in Databricks.

I dont know how to fix this issue. Any idea?

[R1k91 · Accepted solution]

have you already seen recommendations?

Connect to Power BI - Azure Databricks | Microsoft Learn

"

For large imports that take close to one hour or longer, Databricks recommends that you use Azure Databricks personal access token authentication as there is a known token refresh issue when using Azure Active Directory.

"

[v-xinruzhu-msft]

Hi @biuser98 

Please make sure that you are granted permissions with all data sources. You could delete the connections and re-connect to have a try again.And you can try to configure token lifetimes, you can refer to the following link.

Configurable token lifetimes - Microsoft Entra | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.