Forum Discussion
Query Timeout on update
I am pulling in an update from a web source, but this source can take 3 minutes + to return data. Power BI times out before the server responds. I would like to adjust this timeout timer. Can we make this user adjustable setting?
jsquaredz What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.
16 Replies
jsquaredz What you need to do is in power bi desktop go to query editor then right click your web data source and click Advanced Editor. This will give you access to M code behind it. You need to specify timeout interval in there manually. See below image and then should work hopefully.
Thanks for the workaround.
[timeout=#duration(0,0,30,0)]))
Can you share these parameters?
Would like to see this as a setting in the query builder.
>>[timeout=#duration(0,0,30,0)]))
This is a TimeSpan like parameter, with the values representing Days, Hours, Minutes, Seconds.
So, this setting represents a timeout of 30 minutes.
Yes, it works.
you have to add a "null" in between
OData.Feed("http://some.url/service.svc/", null, [Timeout=#duration(0, 0, 5, 0)])
I have this issue in excel where I am referencing a URL in a table. How would this solution be applied as per below?
= Excel.Workbook(Web.Contents(
let
Source = Excel.CurrentWorkbook(),
SpmReports = Source{[Name="SpmReports"]}[Content],
#"Report URL" = SpmReports{6}[Report URL]
in
#"Report URL"
), null, true)
Hello all,
I am also having timeout expired issue on my power bi connection. Not sure what the cause is. I tried to place the timeout duration but still didn't work for me. There is something I am missing that I don't know.
Can someone please guide me. I am running a stroed procedure from sql server.
Thank you
