Issue with importing data into Power BI from a view containing 100 million records in ADB

[Jagadish_Vela]

Hello, everyone. I'm trying to import data into Power BI from a view in Azure Databricks that contains over 10 million records. Every time it's failing with this following error

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [08006] [Microsoft][ThriftExtension] (10) Access tokenexpired: Token is expiring within 30 seconds. (token expired)" 

Is there any workaround for this? I've been struggling with it since yesterday. Any help would be greatly appreciated.

[daniel_sahal]

@Jagadish_Vela 
There are two workarounds - use OAuth or switch to Personal Access Token. Unfortunately that's the only way i know at the moment.

[Jagadish_Vela]

Daniel, I've tried PAT Token. This time I'm getting this Error " 

Details: "ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: connect() failed: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.."

I've followed this 
https://stackoverflow.com/questions/73497033/connectivity-issue-from-power-bi-to-azure-databricks
I might be missing something, please help me out.

[riquedan]

Users have the option of either using OAuth or switching to Personal Access Token as a solution. I am sorry to say that this is the only method I am aware of at the present. hi