Not sure if this is the right section to ask, but using MS 365 Excel Power Query, made 22 Queries with no major issues, but the last one is now giving me a
DataSource.Error: The Web.Page function didn't finish within timeout of 100 seconds.
Am I doing something wrong? can I fix it?
It seemed to work all the way through setting up the data sourcing, but as soon as I try to load it to the spreadsheet it ends up failing on this Timeout issue.
Can anyone help?
let
Source = Excel.CurrentWorkbook(){[Name="Table30"]}[Content],
#"Removed Other Columns" = Table.SelectColumns(Source,{"URL"}),
#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "FetchStyleProfileETF", each fxMDStyleProfileETF()), #"Removed Columns" = Table....cy"}) in #"Expanded FetchStyleProfileETF"
DataSource.Error: The Web.Page function didn't finish within timeout of 100 seconds.
Am I doing something wrong? can I fix it?
It seemed to work all the way through setting up the data sourcing, but as soon as I try to load it to the spreadsheet it ends up failing on this Timeout issue.
Can anyone help?
let
Source = Excel.CurrentWorkbook(){[Name="Table30"]}[Content],
#"Removed Other Columns" = Table.SelectColumns(Source,{"URL"}),
#"Added Custom" = Table.AddColumn(#"Removed Other Columns", "FetchStyleProfileETF", each fxMDStyleProfileETF()), #"Removed Columns" = Table....cy"}) in #"Expanded FetchStyleProfileETF"