topic Re: Issue with importing data into Power BI from a view containing 100 million records in ADB in Get Started Discussions https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74798#M7529 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/108806">@Jagadish_Vela</a>&nbsp;<BR />There are two workarounds - use OAuth or switch to Personal Access Token. Unfortunately that's the only way i know at the moment.</P> Tue, 18 Jun 2024 07:36:42 GMT daniel_sahal 2024-06-18T07:36:42Z Issue with importing data into Power BI from a view containing 100 million records in ADB https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74783#M7528 <DIV class=""><DIV class=""><DIV class=""><DIV class=""><SPAN>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</SPAN></DIV><DIV class=""><SPAN>"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)"&nbsp;</SPAN></DIV><DIV class=""><SPAN>Is there any workaround for this? I've been struggling with it since yesterday. Any help would be greatly appreciated.</SPAN></DIV><DIV class="">&nbsp;</DIV><DIV class=""><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ADB Token Error.png" style="width: 562px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/8780i55953B91E5ABA437/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="ADB Token Error.png" alt="ADB Token Error.png" /></span></SPAN></DIV></DIV></DIV></DIV> Tue, 18 Jun 2024 04:38:03 GMT https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74783#M7528 Jagadish_Vela 2024-06-18T04:38:03Z Re: Issue with importing data into Power BI from a view containing 100 million records in ADB https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74798#M7529 <P><a href="https://community.databricks.com/t5/user/viewprofilepage/user-id/108806">@Jagadish_Vela</a>&nbsp;<BR />There are two workarounds - use OAuth or switch to Personal Access Token. Unfortunately that's the only way i know at the moment.</P> Tue, 18 Jun 2024 07:36:42 GMT https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74798#M7529 daniel_sahal 2024-06-18T07:36:42Z Re: Issue with importing data into Power BI from a view containing 100 million records in ADB https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74852#M7530 <P>Daniel, I've tried PAT Token. This time I'm getting this Error "&nbsp;<BR /><BR />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.."<BR /><BR />I've followed this&nbsp;<BR /><A href="https://stackoverflow.com/questions/73497033/connectivity-issue-from-power-bi-to-azure-databricks" target="_blank" rel="noopener">https://stackoverflow.com/questions/73497033/connectivity-issue-from-power-bi-to-azure-databricks</A><BR />I might be missing something, please help me out.<BR /><BR /><BR /><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pat token error.png" style="width: 548px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/8802i87C26ABE0D31E012/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Pat token error.png" alt="Pat token error.png" /></span><BR /><BR /><BR /><BR /></P> Tue, 18 Jun 2024 13:35:49 GMT https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74852#M7530 Jagadish_Vela 2024-06-18T13:35:49Z Re: Issue with importing data into Power BI from a view containing 100 million records in ADB https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74934#M7531 <P>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</P><P>&nbsp;</P> Thu, 20 Jun 2024 04:28:33 GMT https://community.databricks.com/t5/get-started-discussions/issue-with-importing-data-into-power-bi-from-a-view-containing/m-p/74934#M7531 riquedan 2024-06-20T04:28:33Z