Timout on Credentials

[paulalmond91]

Hi Guys,

I've built a dataset which contains 2 tables with approx 15-20k rows.

I've built a timout clause into the power query to allow for additional time but when I went to setup schedule refresh it is asking for credentials.

I know the credentials are correct as I use the same for smaller tables without issue.

Error I receive:

Failed to update data source credentials: Timeout expired. The timeout period elasped prior to completion of the operation.

Hide details

Activity Id:	42662020-fac0-4b41-9b39-a9c41595363d
Request Id:	484e2424-4717-ecf0-9b9c-309af3524e0b
Status Code:	400
Time:	Thu Oct 29 2015 22:42:59 GMT+0000 (GMT Standard Time)
Version:	11.0.9168.505
Cluster URI:	https://wabi-north-europe-redirect.analysis.windows.net
Details:	Timeout expired. The timeout period elasped prior to completion of the operation.

Any ideas on how I can resolve this to setup schedule refresh?

[v-viyada]

Same Issue Here:

Failed to update data source credentials: Timeout expired. The timeout period elasped prior to completion of the operation.Hide details 
Activity ID: 777a270d-059e-4969-8819-f2e2d5ae8839
Request ID: 1c3d8b61-8790-7247-e650-32f1944154e3
Status code: 400
Time: Mon Apr 10 2017 04:46:19 GMT-0700 (Pacific Daylight Time)
Version: 13.0.1700.1761
Cluster URI: https://df-msit-scus.analysis.windows.net
Details: Timeout expired. The timeout period elasped prior to completion of the operation.

[Jannat]

I am having the same error but i can't find any solution to it. I am using data from google sheet imported to power bi in excel format. I am not able to update the credentials nor the data. 

[paulalmond91]

Hi Jannat,

My solution in the end was to build pagination into my calls.

Depending on the call weight the external server might be timing you out.

This can be done by converting your get data request into a function and then calling the results of this function into another query.

For example:

Our function would be something like:

(page as number) as table =>
let
Source = Json.Document(Web.Contents("https://DOMAIN/",[RelativePath="[API CALL PATH]?_page=" & Number.ToText(page) & ""]))

My initial step is to call a single page model the data how I want it (expand/rename and create any custom columns etc) then update the above.

Add a new custom query with the following:

let
    AddFunctionCall=List.Generate(()=>[Page Number=0,Func=null], each (try _[Func])[HasError]=false, each [Page Number=_[Page Number]+1, Func=YOURFUNCTIONNAMEHERE([Page Number]+1)], each _[Func]),
    ConvertToTable = Table.FromList(AddFunctionCall, Splitter.SplitByNothing(), null, null),
    RemoveDemiRow = Table.Skip(ConvertToTable,1),

What this will do is call the function for each page in the output avoiding the timeout.

[dilumd]

Hi @paulalmond91

I'm also getting the same error now. I'm extracting data via a SQL statement (ODBC connection). can you suggest a solution for this?

Thank you in advance!

Failed to update data source credentials: Timeout expired. The timeout period elapsed prior to completion of the operation.Hide details

Activity ID:	df0639f7-acd1-d4ec-d98a-d1e0517f10d7
Request ID:	2fc28982-b533-d9da-bd16-cde92ffdd484
Status code:	400
Time:	Mon May 14 2018 09:45:59 GMT+0530 (Sri Lanka Standard Time)
Version:	13.0.5248.195
Cluster URI:	https://wabi-south-east-asia-redirect.analysis.windows.net

[paulalmond91]

Sorry for late reply.

If you're still having issues i would suggest you contact PowerBI support as they can see more details on the error and hopefully point you in the right direction.

[nathangraham]

I'm receiving this same error as of 11pm last night and it persists. Suggestions?

[Rflad]

Same issue here :

Failed to update data source credentials: Timeout expired. The timeout period elasped prior to completion of the operation