Forum Discussion
Excel Power Query Connecting to Datasource locks up all Office products
Hi masplin ,
You don’t need to create a separate function for the delay. Just modify your existing QuoteUK/Yahoo function by wrapping the Web.Contents call with Function.InvokeAfter. In the earlier example, x was only a placeholder argument, it's not meant to be your function name.
Here’s how your function should look once the delay is applied:
let
Url = "https://shareprices.com/lse/" & Yahoo & "/",Source =
Function.InvokeAfter(
() =>
Web.Page(
Web.Contents(
Url,
[
Headers = [
#"User-Agent" = "Mozilla/5.0 (Windows NT 10.0; Win64; x64)",
Accept = "text/html",
#"Accept-Language" = "en-GB,en;q=0.9"
]
]
)
),
#duration(0,0,0,1)
)
in
Source
Hope this helps,
Thank you.
Seems to work ok-ish on my pi-hole protected network. Since most of the data sources are accessed in anonymous mode you will want to set the data source privacy to "Ignore" - that will greatly improve performance at the expense of security.
There's at least one data source that balks.
Hi. Where do you se t it to ignore? I can go into power query/ data source settings and set each credential to none/public/organisational. I set the web ones to public
The one that is balking is the main data colelctor that is cycling thorugh the stocks on shareprice.com. When i click refresh in power query it doesnt prompt me for any credentials and you dont need a login to access the webpage, so not sure where I should enter these.
