cancel
Showing results for 
Search instead for 
Did you mean: 
Community Platform Discussions
Connect with fellow community members to discuss general topics related to the Databricks platform, industry trends, and best practices. Share experiences, ask questions, and foster collaboration within the community.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Jagadish_Vela
New Contributor II
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.
 
ADB Token Error.png
3 REPLIES 3

daniel_sahal
Esteemed Contributor

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

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.


Pat token error.png



riquedan
New Contributor II

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

 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group